Registered aircraft · 72,010

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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.

N388JFAspire Aviation LLC · Farmingdale, NYS/N 17276182 N388JGBeggins Thomas J · Madison, CTBuilt 2000 · S/N 2021 N388LBSdgair LLC · Port Orange, FLBuilt 1964 · S/N 30-511 N388LMAlexay Mario F Jr · Portal, AZBuilt 2009 · S/N 80150 N388METrinity Aviation Group LLC · Hudson Oaks, TXBuilt 1955 · S/N 23-322 N388MJSundance Aero LLC · Mertzon, TXBuilt 2001 · S/N 3224 N388MKRegistered aircraftBuilt 1989 · S/N MVK1988 N388NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2023 · S/N 2881679 N388PGAviator Air Flight School LLC · Grand Prairie, TXBuilt 1972 · S/N 17260525 N388PSDarrow Matthew J · Truckee, CABuilt 1986 · S/N 5116 N388TWeimer David J · Knightstown, INBuilt 1973 · S/N 32-7440044 N388XWarner Walt M · Willow, AKBuilt 1976 · S/N 7018C N38900Thompson Henry S · Plantsville, CTBuilt 1977 · S/N 28-7790604 N38901Weintraub Beverly · New York, NYBuilt 1977 · S/N 28-7790606 N38908Mollere Michael E · Marion, TXBuilt 1977 · S/N 32R-7780487 N3890KClark David L · Arlington, TXBuilt 1946 · S/N 1283 N3890WRobinson Mark A · Carson City, NVBuilt 1967 · S/N 32-914 N3890ZIngman Joshua P · Dickinson, NDBuilt 1961 · S/N 18-7706 N38910Sitta Donald C · Farmington, NMBuilt 1940 · S/N AP833 N38911Sams Aviation LLC · Decatur, ILBuilt 1977 · S/N 32R-7780488 N38912Congco Antoine Mark J · New Caney, TXBuilt 1977 · S/N 32R-7780489 N38914Acadian Aviation Pilot Training Centre Inc · Lafayette, LABuilt 1977 · S/N 28-7716291 N38919Sale Reported · Sarasota, FLSale reportedBuilt 1977 · S/N 28R-7737123 N3891FJjcw Aviation Inc · Athens, TXBuilt 1976 · S/N 32R-7680407 N3891QRiley George L III · Washington, INBuilt 1971 · S/N 17259991 N3891TJones Rodney D · Corcoran, CABuilt 1967 · S/N 28R-30220 N3891ZLaudon Sydney L · Anchorage, AKS/N 18-7707 N3892KRowley Rodney N · Duchesne, UTS/N 28-23763 N3892NNeed For Speed Inc · Dover, DEBuilt 1968 · S/N 680145 N3892QKcn Aero Club Inc · Overland Park, KSS/N 17259992 N3892ZWinston Christopher C · Vancouver, WABuilt 1961 · S/N 18-7708 N3893QSisung Ty J · Roxie, MSBuilt 1971 · S/N 17259993 N38945Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1977 · S/N 32R-7780490 N3894FNorth Shore Aero Club · Beverly, MABuilt 1976 · S/N 28-7690459 N3894TBsa Leasing LLC · Pocatello, IDBuilt 1967 · S/N 28R-30223 N3894WElite Fleet Jacksonville LLC · Jacksonville, FLBuilt 1966 · S/N 32-840 N38952Ponto Phillip R · Vista, CABuilt 1977 · S/N 28-7716297 N38954Faulkner Wade DBA · Sterrett, ALBuilt 1977 · S/N 28-7716299 N3895FGreever Steven M · Spearman, TXBuilt 1977 · S/N 28R-7737002 N3895TPaetzold Carson · Jacksonville, FLBuilt 1967 · S/N 28R-30224 N38968Vagabond Flying Association · Winfield, ILBuilt 1977 · S/N 28-7716300 N38969Vandervelden Harmen J · Ware, MABuilt 1977 · S/N 28-7716301 N3896FEssary Larry R · Mc Neal, AZS/N 28R-7635376 N3896QNishna Valley Flying Club · Red Oak, IABuilt 1971 · S/N 17259996 N3896ZDriggs Daniel H · Anchorage, AKBuilt 1961 · S/N 18-7674 N38970Triple R Aviation LLC · Cleburne, TXBuilt 1977 · S/N 28-7716302 N38972August Aero LLC · Kalispell, MTS/N 28-7716304 N38974International Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 28-7716305 N3897XRegistration Pending · Greenwood, INRegistration pendingBuilt 1967 · S/N 134 N3897ZWard Joseph Delon · Wasilla, AKS/N 18-7788

Back to AD 87-10-06 R1