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.

N5455JFriend John M · Ozawkie, KSBuilt 1980 · S/N 17273801 N5455MMacomb Air Inc · Denver, NCS/N 706 N5455PWheeler Douglas A · Mount Vernon, OHS/N 24-511 N54569Buehler Thomas M · Renton, WABuilt 1981 · S/N 17275002 N5456LHeath Jackie N · Radcliff, KYBuilt 1973 · S/N AA5-0356 N5456PYates Kenneth B · New Boston, TXS/N 24-512 N54576Rick Aviation Inc · Newport News, VAS/N 17275003 N5457DSanders Flight Training Center Inc · Jasper, ALS/N 17272574 N5457ETravis Gregory R · Bloomington, INFirst renewal noticeBuilt 1978 · S/N 17271873 N5457JRegistration Pending · Chino, CARegistration pendingBuilt 1980 · S/N 17273803 N5457STyler David G · Accomac, VABuilt 1971 · S/N 28-7125123 N54589Twin City Cloud 7 Inc · Eden Prairie, MNBuilt 1981 · S/N 17275007 N5458MPagratis Periklis · Savannah, GABuilt 1970 · S/N 28-5809 N5459HWard John W · Troutdale, ORBuilt 1975 · S/N 17265452 N5459KPropability One LLC · Daytona Beach, FLBuilt 1980 · S/N 17274125 N5459LNicola Gary L · Lansing, MIBuilt 1974 · S/N AA5-0639 N5459PAirclimax Inc · Milan, TNBuilt 1958 · S/N 24-516 N545AMMidwest Corporate Air Inc · Bellefontaine, OHBuilt 2005 · S/N 40.526 N545CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 2881054 N545DSAero Maintenance Inc · Vancouver, WABuilt 1980 · S/N 17273867 N545EABrad Wursten Airshows · Logan, UTBuilt 2009 · S/N 9 N545FLWiegand Andrew S · Enterprise, ALS/N 28-7125378 N545JCCdg Aviation LLC · Cresson, TXBuilt 1995 · S/N 2634 N545JPDavis Richard L · Kenai, AKBuilt 1996 · S/N 1737 N545MASkywest Leasing Inc · St George, UTBuilt 2017 · S/N 2843865 N545MCBarnes Robert Edward Jr · Mason, OHBuilt 1999 · S/N 18280530 N545PGGore Equipment Leasing LLC · Griffin, GABuilt 2009 · S/N 40565 N545SFCrabtree William D · Big Lake, AKBuilt 2026 · S/N 001 N545SMWood Kyle Aubrey · Soldotna, AKBuilt 1999 · S/N 545 N545WAStine Scott A · Vincennes, INBuilt 1968 · S/N 28R-30577 N545WHBledsoe Bobby H · Hot Springs, ARBuilt 2000 · S/N 32-46156 N545WRCumulus Aviation Services LLC · Port Orange, FLBuilt 1972 · S/N 28R-7235119 N545WWGrisham Michael H · Paulden, AZBuilt 1955 · S/N 22-3320 N5460NWylie David · Sharon Springs, NYBuilt 1968 · S/N 28-3800 N5460PT & C R Wing'N It LLC · Tempe, AZBuilt 1958 · S/N 24-517 N5461KFaragallah Allan A · Garden Grove, CABuilt 1980 · S/N 17274127 N5461LClinton Lance D · Lago Vista, TXBuilt 1974 · S/N AA5-0511 N5461PGraham Truett A · Lubbock, TXBuilt 1958 · S/N 24-518 N5461RRegistered aircraftBuilt 1998 · S/N 35 N5461SCarter Kenneth M Jr · Castle Rock, COBuilt 1980 · S/N R18201577 N5461WGarvey David G · Erie, PAS/N 28-541 N54621Atlantic Resources Of Miami Inc · Deland, FLS/N 27-7554036 N54628Ohio State University · Columbus, OHBuilt 1981 · S/N 17275013 N5462LGilbert Jason J · Oakland, MEBuilt 1973 · S/N AA5-0362 N5462QLeading Edge Flight Academy LLC · Bend, ORBuilt 1973 · S/N 17261792 N5462THebert David · Lafayette, LABuilt 1982 · S/N R18201874 N54633Warner Walter M · Willow, AKBuilt 1981 · S/N 17275016 N54634Savannah Airplane Venture LLC · Myrtle Beach, SCBuilt 1981 · S/N 17275017 N54635Memphis Navy Flying Club · Millington, TNBuilt 1981 · S/N 17275018 N5463KRick Aviation Inc · Newport News, VABuilt 1980 · S/N 17274129

Back to AD 87-10-06 R1