Registered aircraft · 20,481

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N5127EWalters Donald J · Wickenburg, AZBuilt 1959 · S/N 50427 N5127NSierra Breeze LLC · Springfield, MOS/N 18267534 N5127QRegistered aircraftBuilt 1972 · S/N 21059627 N5127UFowler Ron W · Lopez Island, WAS/N 206-0127 N5128EButt Thomas P · Whitt, TXBuilt 1959 · S/N 50428 N5128HWelsh Rolland R · Shady Shores, TXBuilt 1981 · S/N 18267863 N5129DPolatis Daniel T · Pingree, IDS/N 51229 N5129ETjr Aviation LLC · Orefield, PABuilt 1982 · S/N 18268290 N512ATRanch Aero LLC · Sterling City, TXBuilt 1975 · S/N 21060721 N512GTBarron Thomas Aviation Inc · Scottsdale, AZBuilt 1974 · S/N 21060178 N512JGJacobs Gareth · Woodruff, SCBuilt 1972 · S/N 18261972 N512KMWhite Holdings LLC · Washington, INBuilt 1975 · S/N 18263878 N512TWDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 1978 · S/N 21063034 N5130AAll Florida Aviation Inc · West Palm Beach, FLBuilt 1979 · S/N 21063280 N5130YMerritt LLC · Leesburg, VABuilt 1980 · S/N 21064087 N5131NPiedmont Aircraft LLC · North Myrtle Beach, SCBuilt 1980 · S/N 18267538 N5131QLeavitt Craig S · Spicewood, TXBuilt 1972 · S/N 21059631 N5131T3b'S Land Development LLC · Seattle, WAS/N R18201821 N5132EFicklin Thomas L · Fairbury, ILBuilt 1959 · S/N 50432 N5133DPalmer Ross G · Las Cruces, NMBuilt 1958 · S/N 51233 N5134DWheeler Robert L · Nampa, IDBuilt 1958 · S/N 51234 N5136N5136n LLC · Las Vegas, NVBuilt 1980 · S/N 18267540 N5137DNeuschwander Raymon J · Canby, ORS/N 51237 N5138DUrlaub James E II · Phoenix, AZS/N 51238 N5139DEdwards A Clay · Weaverville, CABuilt 1958 · S/N 51239 N5139QNykerk Kory · San Miguel, CABuilt 1972 · S/N 21059639 N513MCWilliams Val · Victor, IDBuilt 2006 · S/N 18281811 N513SCInstant Whip Foods Inc · Columbus, OHBuilt 1978 · S/N 18266293 N513TDWeber Sandra L · Simpsonville, SCBuilt 1997 · S/N 18280030 N5141ESkywagon 41 Echo LLC · Pine, COBuilt 1959 · S/N 50441 N5141JSasser Nancy Elizabeth · Petaluma, CABuilt 2001 · S/N 18281062 N5141QImagination Publications Inc DBA · Saratoga, WYBuilt 1972 · S/N 21059641 N5141YCommonwealth Of Virginia · Fort Monroe, VABuilt 2002 · S/N 18281077 N5142EBedford Dennis L · Auke Bay, AKBuilt 1959 · S/N 50442 N5143DMacbeth Keith Adam · Thompson, UTS/N 51243 N5144NL-3 Communications Eo/Ir Inc · Loveland, COBuilt 1979 · S/N 18267543 N5144UAeronaut LLC · Saint George, UTBuilt 1984 · S/N 21064851 N5146DAnderson Daniel S · Payson, AZS/N 51246 N5146QJ&G Aero Investments Group LLC · Wilmington, DEBuilt 1972 · S/N 21059646 N51472Breaks Bound LLC · Kalispell, MTBuilt 1966 · S/N 18256977 N5148DNick Peak Flying LLC · Mccall, IDBuilt 1958 · S/N 51248 N5148EQuandary Consulting Group LLC · Greenwood Village, COBuilt 1959 · S/N 50448 N514DPPitts Donald W · Sand Springs, OKBuilt 1960 · S/N 52546 N514FCState Of Alabama · Montgomery, ALBuilt 2024 · S/N 18283282 N514GCCristan Gene V · Lake Mary, FLBuilt 1956 · S/N 33356 N514HPState Of Ohio / Department Of Public Safety · Columbus, OHBuilt 2005 · S/N 18281651 N514KKSchaperkotter Harold M Jr · Anchorage, AKBuilt 1960 · S/N 50796 N514MRDmc Holdings LLC · Bullard, TXBuilt 2012 · S/N 18282328 N514NYJones Christopher S · Twin Falls, IDBuilt 2010 · S/N 18282271 N514TPactolus Investments LLC · Blounts Creek, NCBuilt 1980 · S/N U20605940

Back to AD 84-10-01 R1