Registered aircraft · 22,428

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-08-08-R3') 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-08-08-R3') 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-08-08-R3')
    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-08-08-R3')
  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-08-08-R3')
  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-08-08-R3')
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.

N1177XParrish View Farms · Kenbridge, VABuilt 1975 · S/N 28-7510086 N1178XN1178x LLC · Dover, DEBuilt 1975 · S/N 28-7505220 N1179XDesch Edward J III · Aldie, VABuilt 1975 · S/N 28R-7535267 N117BCGiardina Edward Charles Jr · Cranston, RIBuilt 1977 · S/N 28-7790565 N117CSSam Airlines LLC · Wilmington, DEBuilt 1996 · S/N 32-46024 N117DBHawley Vance L · Idaho Falls, IDBuilt 1979 · S/N 28-7990284 N117DWFerrand Kathy M · Cornelia, GABuilt 1973 · S/N 28-7325669 N117GHAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2001 · S/N 3257217 N117HWYale Companies LLC DBA · Fishers, INBuilt 2026 · S/N 2881998 N117JCHillsboro Flying Club · Hillsboro, ORBuilt 1980 · S/N 32-8006032 N117MBLittmarck Svante · Dedham, MABuilt 2014 · S/N 2844151 N117MTHinkle Robert J · Caldwell, IDS/N 28-21374 N117RKAlon Guy · El Paso, TXBuilt 1979 · S/N 28R-7931068 N117SCJenkins Matthew A · Bend, ORS/N 28R-7703343 N117SEHalsell Jason · Wolfforth, TXBuilt 2004 · S/N 3255017 N117TKWindstar Air LLC · Carroll, IABuilt 1979 · S/N 28-7990546 N117VRAtmospheric Vehicle & Spacecraft Flght Exploration · Rch Palos Vrd, CABuilt 1968 · S/N 28R-30443 N1180XK & K Aero Inc · Wilmington, DEBuilt 1975 · S/N 32-7540152 N1181HAdams Dustan David Sr · Houma, LAS/N 28-7715313 N1184DZwick Noah Geary · Dunkirk, MDBuilt 1967 · S/N 28-23130 N1184XLairson Samuel E III · Ocean City, NJBuilt 1975 · S/N 28-7505221 N1185HJcaviator LLC · Matthews, NCS/N 28-7715314 N1185XWilliamson Flying Club Inc · Williamson, NYBuilt 1975 · S/N 28-7505222 N1188TAbrams Jeffrey Scott · Phoenix, AZBuilt 1964 · S/N 28-1883 N1188XSteven H Baker Construction Co · Big Bear City, CABuilt 1975 · S/N 28R-7535274 N118BJOn Final Aviation LLC · Brookland, ARBuilt 1977 · S/N 28-7890125 N118ESCmv Aviation LLC · Johnson City, NYBuilt 1976 · S/N 32R-7680374 N1190HBergman William George · Muskegon, MIBuilt 1977 · S/N 28-7716002 N1191HBurford John W Trustee · Madison, MSS/N 28-7790294 N1194HCrnic Paul C · Chesterfield, MOS/N 28R-7703016 N1196XMedic Choppers LLC · Springdale, ARS/N 28-7525279 N1198HAlge Aviation · Middletown, DES/N 32R-7780143 N1198XDiscover Aviation Center LLC · Elyria, OHBuilt 1975 · S/N 28-7505223 N119A2is Partners LLC · Vero Beach, FLBuilt 1969 · S/N 28-25947 N119AVFour Mac Air LLC · San Diego, CABuilt 1984 · S/N 28-8490079 N119BTDelaware US Investments LLC · Corpus Christi, TXBuilt 2022 · S/N 2881522 N119GGYepes Hurtado Andres F · Lubbock, TXBuilt 1978 · S/N 28R-7931008 N119GSDall James R Jr · Hayes, VABuilt 1985 · S/N 32R-8529009 N119HPValiair Limited Company Trustee · Casper, WYBuilt 1966 · S/N 28-21570 N119JDUSA Wiltshire LLC · Pembroke Pines, FLBuilt 1969 · S/N 28-25406 N11CASky Dragon LLC · Atlanta, GAS/N 28-8190077 N11CWJabez Aviation LLC · Petaluma, CABuilt 1977 · S/N 28R7737079 N11FLBell Christopher K · Ashley, OHBuilt 1968 · S/N 28R-30444 N11GERusso James F · Liberty, SCBuilt 1972 · S/N 28-7325081 N11GKBaden Michael · Waxhaw, NCS/N 28-23403 N11GNHaley James M Trustee · Edmond, OKBuilt 1973 · S/N 28-7305330 N11HAVintage Aero Inc · Brandon, FLBuilt 1973 · S/N 28-7305338 N11HKJohnson Wendell F · Harlingen, TXBuilt 1981 · S/N 32R-8129071 N11JUPottorff Gregory K · Wayne City, ILBuilt 1973 · S/N 28R-7335374 N11KAlbers Edward C · Burlington Flats, NYBuilt 1968 · S/N 28-4725

Back to AD 87-08-08 R3