Registered aircraft · 22,430

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.

N1693TMoburg Kenneth · Basehor, KSS/N 28-7125010 N1694JLeemans Scott J · Queen Creek, AZBuilt 1967 · S/N 28-24099 N1695HVista Air Inc · Pacoima, CABuilt 1977 · S/N 28-7725155 N1695JHudson John P III · Grapeland, TXS/N 28-24101 N1696JHardin John M · Terrell, TXS/N 28-24102 N1696TAircraft 1821 LLC · North Charleston, SCS/N 28-7125013 N1697HOwen Richard L · Milton, DES/N 28-7716046 N1699HFitzpatrick Yuma T · Blakely Island, WABuilt 1977 · S/N 28-7790335 N1699TBurgess Frank A Jr · Durham, NCS/N 28-7125016 N169AGSkywest Leasing Inc · St George, UTBuilt 2024 · S/N 2881810 N169BTAtkison Keith · Centre, ALBuilt 1966 · S/N 28-3776 N169BWFarris Frederick J · Sandpoint, IDBuilt 1978 · S/N 32R-7885080 N169DBFrench David D · Tallahassee, FLBuilt 1969 · S/N 28R-35150 N169JPBoggs Mitchell · La Russell, MOBuilt 1972 · S/N 28R-7235262 N169LHFarmingdale State College · Farmingdale, NYBuilt 2020 · S/N 2881375 N16ABMasselink Ross W · Whitewater, KSBuilt 1967 · S/N 32-40245 N16AKGriffin Steven M · Enterprise, ALS/N 28R-7918057 N16BJMarshall John Robert · Missouri City, TXBuilt 1979 · S/N 32R-7987115 N16ECSchnell Michael D · New Bremen, OHBuilt 1965 · S/N 28-2683 N16EMB J Air Ltd · Howard, OHBuilt 1976 · S/N 32R-7680228 N16HLPlane Fun Inc Tr Trustee · Snellville, GABuilt 1968 · S/N 28R-30675 N16JPTrue Grit Wy 2 DBA · Rozet, WYBuilt 1969 · S/N 28-25956 N16JSMace Terry G · Saint James, MNBuilt 1973 · S/N 28R-7335304 N16RJParagon Airplane Leasing Co · Fort Myers, FLBuilt 2024 · S/N 28020193 N16RLKerr John A Jr · Dekalb, ILBuilt 1964 · S/N 28-1834 N16TJJean-Louis Lesly G · Loxahatchee, FLBuilt 2004 · S/N 3232034 N1700JStratus Aviation LLC · Newnan, GABuilt 1967 · S/N 28-24107 N1701EValiair Limited Co Trustee · Casper, WYBuilt 1978 · S/N 32R-7885002 N1701TRd Aire LLC · Opelika, ALBuilt 1970 · S/N 28-7125018 N1702HHesston College · Hesston, KSBuilt 1977 · S/N 28-7790336 N1703JCogan Betty C · Bristol, TNBuilt 1968 · S/N 28-24111 N1703TAlicea Ismael · Iselin, NJBuilt 1970 · S/N 28-7125019 N1704TLavieri Gary P · Seneca, SCBuilt 1970 · S/N 28-7125020 N1705JPeel William · Gilbert, AZBuilt 1968 · S/N 28-24113 N1705MYeager Jacob M · Ignacio, COBuilt 1975 · S/N 28R-7535260 N1705TLubeski Lawrence J · Lapeer, MIBuilt 1970 · S/N 28-7125021 N1706JSkycastle Flying Club Inc · New Castle, INBuilt 1968 · S/N 28-24114 N1706TMarshall Loraine · Independence, KYS/N 28-7125022 N17079Speakman Donna M · Auburn, ALBuilt 1965 · S/N 28-2157 N1707HCyberflight Inc · Wilmington, DEBuilt 1977 · S/N 28R-7737010 N1708TN1708t Owners Assn · Chesapeake, VABuilt 1970 · S/N 28-7125023 N1709JWingman Unlimited LLC · Carrollton, TXBuilt 1968 · S/N 28-24118 N170LHFarmingdale State College · Farmingdale, NYBuilt 2020 · S/N 2881376 N1710JOpen Skies Aviation LLC · Wellington, KSBuilt 1968 · S/N 28-24119 N1710TGarretson Thomas A · New Smyrna Beach, FLBuilt 1970 · S/N 28-7125025 N1711TLeadturn LLC · San Diego, CABuilt 1976 · S/N 28-7610075 N17123Wieszkowiak Thomas J · Sunbury, PABuilt 1976 · S/N 32R-7680327 N1712JTwelvejuliet LLC · Moberly, MOBuilt 1968 · S/N 28-24123 N1712TLea Joe A · Mason City, IABuilt 1970 · S/N 28-7125026 N1713JSimpson Mark E · Fairbanks, AKBuilt 1968 · S/N 28-24124

Back to AD 87-08-08 R3