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.

N4213YFandrich Edward I · Payson, AZS/N 341-77 N4214HGranger Andrew J · Denver, COS/N 14-101 N4214MLawler Helicopter Leasing LLC · Rochester, MIBuilt 2009 · S/N 2008 N4214QMms Aircraft Leasing LLC · Williamsburg, VABuilt 1971 · S/N 17260114 N4215HDavis John N · Port Alsworth, AKBuilt 1948 · S/N 14-18 N4215TBaker Michael D · Berlin, PABuilt 1971 · S/N 32-7200011 N4215YCg Air LLC · Mason City, IABuilt 1977 · S/N 968-77 N42161Registered aircraftS/N 28-7425312 N42167Howarth Jason A · Lancaster, PABuilt 1974 · S/N 28-7415383 N42168Registration Pending · Denton, TXRegistration pendingBuilt 1974 · S/N 28-7415384 N4216RJeffordspaul · Naperville, ILBuilt 1969 · S/N 32-40581 N4216TExtreme Metals LLC · El Dorado, ARBuilt 1971 · S/N 28-7205102 N4216YTusquittee Flyers Aero Club LLC · Hayesville, NCS/N 345-77 N4216ZGleason Egan · Valdez, AKBuilt 1966 · S/N 18-8437 N42178Montana Dept Of Transportation · Helena, MTBuilt 1999 · S/N T20608032 N4217JShuffler David · Kingman, AZBuilt 1966 · S/N 28-22565 N4217PInternational Air Services Inc Trustee · Carson City, NVS/N 23-1710 N4217TBentzen David A · Deer Park, WABuilt 1968 · S/N 28R-30975 N4217ZSchock Erik D · Wasilla, AKBuilt 1974 · S/N 18-7409043 N4218HGenna Aviation LLC · Newfield, NJBuilt 1978 · S/N 24-0665 N4218PPn4 Aviation Holdings LLC · Bishop, CAS/N 23-1711 N4218QSavant John D · Kinder, LAS/N 17260118 N4218TGolden Pick LLC · Maple Plain, MNS/N 28-7225096 N4218UJakks Inc · Wilmington, DEBuilt 1999 · S/N T20608035 N4218YDaniels David R · El Paso, TXBuilt 1955 · S/N 18-2510 N4219FHazellief Quillie J Jr · Okeechobee, FLBuilt 1958 · S/N 46119 N4219HHardman Lorin D · Wasilla, AKBuilt 1948 · S/N 14-22 N4219QAudrain Flying Club Inc · Mexico, MOS/N 17260119 N4219T19t LLC · Columbia, MOBuilt 1971 · S/N 32-7240037 N4219ZBubber Inc · Lake Providence, LABuilt 1966 · S/N 18-8442 N421ACCroft Dennis W · Spencerville, OHBuilt 1966 · S/N 1066 N421AKMcgregor Grant · Chugiak, AKBuilt 2023 · S/N 001 N421BSSell Robert O · Prescott Valley, AZBuilt 2004 · S/N 90247 N421BTJolley Robert W · Comanche, TXBuilt 2001 · S/N 23786 N421CVRed-Tailed Hawks Aviation Academy Inc · Mukilteo, WABuilt 1979 · S/N 17272437 N421DLLaplant James R · Newton, IABuilt 1974 · S/N 28-7415326 N421FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLBuilt 2004 · S/N 18281495 N421KRAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2004 · S/N T18208308 N421MJLevine Jonathan L · Waterford, CTBuilt 2000 · S/N 2843338 N421PTRozneck Paul E · Edmond, OKBuilt 2006 · S/N 22487 N421SARedbreast Aviation LLC · Boonton, NJBuilt 2004 · S/N 18281378 N421SGElevate Our Vetrans Ltd · Meridian, IDBuilt 2003 · S/N 6059 N421TBHale Concepts LLC · Marietta, OHBuilt 2002 · S/N 2081 N422Datum Aviation LLC · Milton, FLBuilt 2000 · S/N 777 N4220GVoorhies Danny L · Albertville, ALBuilt 1999 · S/N 21068C N4220HHutchinson Keith M · Lancaster, TXBuilt 1978 · S/N 24-0666 N4220JHisghman Jonathan G · Waynesboro, VABuilt 1966 · S/N 28-22568 N4220RFoster Carl G · Tucson, AZBuilt 1969 · S/N 32-40585 N4220TMartin Thomas Arthur · Great Falls, VABuilt 1972 · S/N 32-7240057 N4220ZLonon Michael E · Yuba City, CABuilt 1966 · S/N 18-8443

Back to AD 87-10-06 R1