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.

N5012MBig Bend Community College · Moses Lake, WABuilt 1978 · S/N MB-882 N5012NSouto Nathan J · Clearwater, FLBuilt 1983 · S/N BG-AA-2 N5012REmd Aviation LLC · Carlsbad, CABuilt 1978 · S/N R18200626 N5012WAllen Michel D · Essex Jct, VTBuilt 1961 · S/N 28-13 N5013RBarxbar Aviation LLC · Mesa, AZBuilt 1974 · S/N 17263254 N5013SFlightworks LLC · North Myrtle Beach, SCBuilt 1970 · S/N 28R-35740 N5013TDasilvafontoura Peterson · Santa Clarita, CABuilt 1972 · S/N 28R-7235173 N5014PSky Valley Aviation LLC · Waverly, IAS/N 24-17 N5014SGandy Austin T · Channelview, TXS/N 32-7100018 N5014TGalati David R · Sebring, FLBuilt 1972 · S/N 32-7240098 N5015HKnox Fred · Los Altos, CABuilt 2001 · S/N T18208096 N5015WCarman Christopher S · Iuka, MSBuilt 1961 · S/N 28-16 N5016SMccartan Gary · Pocahontas, IABuilt 2003 · S/N 01 N5017MNo Limits Aviation Inc · Lincoln, MTS/N ME-54 N5017RR&R Leasing LLC · Fargo, NDBuilt 1974 · S/N 17263258 N5018PTseng Leon Y · Tucson, AZBuilt 1958 · S/N 24-21 N5018UFlight Gate LLC · Wilton, CABuilt 1993 · S/N 2279 N5018YHighland Rim Aviation LLC · Springfield, TNBuilt 1963 · S/N 27-2020 N50193Folsom Gary A · Marianna, FLBuilt 1974 · S/N 17264196 N5019SGordon Patricia I · Desoto, TXS/N 28R-35751 N5019WShipley Kelly R · Astoria, ORBuilt 1961 · S/N 28-20 N501AHOlah Gregory J · High Point, NCBuilt 1966 · S/N MB-80 N501BAFalcon Air LLC · Orlando, FLS/N 326-72 N501BCJamestown Jet Center Inc · Jamestown, NDBuilt 1973 · S/N 27-7305157 N501BSBlue Skies Enterprises Of Texas · Richmond, TXBuilt 2005 · S/N 1005-2005 N501BTCloud Chasers LLC · Columbus, MSBuilt 1976 · S/N 32R-7780039 N501DWParmar Bluffs LLC · Parker, SDBuilt 1996 · S/N 939-76 N501EHDupont Pierre B · Menominee, MIBuilt 1966 · S/N 5 N501ERVista Air Inc · Pacoima, CABuilt 2001 · S/N 172S8947 N501GLSharp Aviation LLC · Pauls Valley, OKBuilt 1973 · S/N 0501 N501GTPollux Aviation Ltd · Wasilla, AKBuilt 2005 · S/N 10768 N501HLAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 1995 · S/N 2500 N501JAAlongi John J · Downers Grove, ILBuilt 1990 · S/N 501-R N501LFMilchev Valentin · New Hampton, NHBuilt 1995 · S/N 1758 N501MAContinental Aerospace Technologies Inc · Mobile, ALBuilt 2021 · S/N 2881479 N501MERoby Gregory Carl · Owensboro, KYS/N 11 N501MPManzoor Khan · Stockton, CABuilt 1978 · S/N 17270318 N501PLDick Timothy R · Fox Lake, ILBuilt 2001 · S/N 5272 N501RDBackcountry Endeavours LLC · Dassel, MNBuilt 1992 · S/N 2164 N501REIndependence Aerospace LLC · Kennesaw, GABuilt 1963 · S/N 30-194 N501RVSaunders Steven M · Elizabeth City, NCBuilt 2006 · S/N 90305 N501SDNordeen Christopher L · Salinas, CABuilt 1986 · S/N 8088C N501SGMccair LLC · Mineral Wells, TXBuilt 1983 · S/N 32-8306003 N501TSFlying Tigers Flight School LLC · Houston, TXBuilt 1976 · S/N 17266839 N501WPTrue Course Aviation LLC · Ashville, NYBuilt 1977 · S/N 32R-7780476 N501ZNorth Georgia Helicopters Inc · Calhoun, GAS/N 18-7836 N50208Haus Jesse M · Fort Worth, TXBuilt 1974 · S/N 17264197 N5020ABrown Jonathan Corey · Sherman Oaks, CABuilt 2001 · S/N T18208097 N5020HBorreson Anthony · Mariposa, CABuilt 1975 · S/N 17265303 N5020PThurston Steven C · Salisbury, NCBuilt 1958 · S/N 24-23

Back to AD 87-10-06 R1