Registered aircraft · 54,017

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-20-03-R2') 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-20-03-R2') 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-20-03-R2')
    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-20-03-R2')
  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-20-03-R2')
  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-20-03-R2')
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.

N53380Haltom Gary D · Alva, OKS/N 15283540 N53387Reifsnyder Daniel S · Lewistown, PABuilt 1981 · S/N 17274738 N5338AThompson Richard T · Wilmington, OHBuilt 1979 · S/N 21063376 N5338QFly By Knight LLC · Louisville, KYBuilt 1972 · S/N 15073238 N5338TKidd Cody M · Martinsville, OHS/N 17251238 N5338UWatermelon Packer Ll · Mcallen, TXBuilt 1984 · S/N 21064871 N5338VMassie Patrick J · Friendswood, TXBuilt 1980 · S/N 172RG0509 N53391Schwend Brian · Forsyth, MTBuilt 1974 · S/N 18801805T N5339BFiebig Howard J · Sebewaing, MIBuilt 1979 · S/N 15283841 N5339DTang Hong-Ming · San Dimas, CABuilt 1979 · S/N 17272528 N5339HBering Capital LLC · Anchorage, AKBuilt 1975 · S/N 17265407 N5339KNordell Kent D · Staples, MNBuilt 1980 · S/N 17274071 N5339NMaine State Police · Augusta, MES/N 18267656 N533KAKamaka Air LLC · Honolulu, HIBuilt 1973 · S/N 20700216 N533SJLns LLC · Wichita, KSBuilt 1978 · S/N 17271533 N533TDChristopher Schultheis Inc · Colton, WABuilt 1962 · S/N 18253879 N53402Anvab Inc DBA · Concord, NHBuilt 1981 · S/N 17274743 N5340TRundell Lanny · Winnsboro, LABuilt 1964 · S/N 17251240 N5340WHebel Ryan · North Potomac, MDBuilt 1981 · S/N P21000675 N5340YCripe Michael L · San Luis Obispo, CABuilt 1980 · S/N 21064173 N53418N53418 LLC · Orlando, FLBuilt 1974 · S/N 33701611 N5341HHoffman Calhoun E · Barnwell, SCBuilt 1975 · S/N 17265408 N53420Kropp Christian Trustee · Azle, TXBuilt 1974 · S/N 33701613 N5342DCornell Timothy R · Hartland, WIS/N 17272531 N5342PSp Airparts LLC · Moscow, IDBuilt 1981 · S/N 15284921 N5342SFranco Gloria J · Las Vegas, NVS/N 337-0442 N53434Caswell Jeff S · Durham, CABuilt 1974 · S/N 33701621 N53437Vineyard Eddie E · Wapello, IABuilt 1981 · S/N 17274749 N5343BSkydive Moab LLC · Moab, UTFirst renewal noticeBuilt 1956 · S/N 33343 N5343DHusnik Brad M · Forest Lake, MNBuilt 1958 · S/N 50241 N5343RMcmahon Michael E · Porterfield, WIBuilt 1965 · S/N 17252871 N5343SRayham LLC · Oxford, GABuilt 1980 · S/N R18201549 N53449Hyde Russell M · Rutherfordton, NCS/N 33701631 N5344BJohn Annin LLC · Fenton, MOBuilt 1979 · S/N 15283843 N5344CThomas Robert S · Caddo Mills, TXBuilt 1948 · S/N 18529 N5344DAirgo Inc · Centralia, ILBuilt 1979 · S/N 17272532 N5344HA&F Aviation Services LLC · Collierville, TNBuilt 1975 · S/N 17265409 N5344KBoeing Employees Flying Assoc · Renton, WABuilt 1980 · S/N 17274074 N5344MPinger Kevin R · Palo Alto, CABuilt 1980 · S/N 15284548 N5344QGraber Quinten R · Brooksville, MSS/N 15073244 N5344RMoxley Michael D · Spearfish, SDBuilt 1965 · S/N 17252872 N53456Amelia Reid Aviation LLC · San Jose, CABuilt 1981 · S/N 17274754 N5345MNew Orleans Aerial Tours & Flight Training LLC · New Orleans, LABuilt 1980 · S/N 15284549 N5345QRegistered aircraftBuilt 1972 · S/N 15073245 N5345TBerrong Jimmy L Sr · Dahlonega, GABuilt 1964 · S/N 17251245 N53463Fara Nick · San Anselmo, CABuilt 1981 · S/N 17274758 N5346BSale Reported · Jasper, TXSale reportedS/N 33346 N5346DBoldflight LLC · Greenwood, INBuilt 1979 · S/N 17272534 N5346EOsprey Holding Company LLC · Foley, ALBuilt 1977 · S/N 17269573 N5346KUsaeroflight LLC · Greenville, SCS/N 17274075

Back to AD 87-20-03 R2