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.

N3241AAirway Science For Kids Inc · Portland, ORBuilt 1953 · S/N 25885 N3241LDostroph Manfred J · Lewis Center, OHBuilt 1967 · S/N 17256141 N3241TMaggart Daniel J · Winchester, ILBuilt 1967 · S/N 17700541 N3241YNull James A III · Live Oak, TXBuilt 1962 · S/N 18254241 N3242CPelski Aviation LLC · Ocala, FLBuilt 1978 · S/N R18200259 N3242SBateman Amber · Elizabeth City, NCBuilt 1964 · S/N 18255742 N3242TSt Clair Ronnie M · Cochise, AZBuilt 1967 · S/N 17700542 N3242YShadow Air LLC · Norfork, ARS/N 18254242 N3243AChristie Bruce W · Wasilla, AKBuilt 1953 · S/N 25887 N3243UGlobe Motorcycles Ltd Inc · Pembroke Pines, FLBuilt 1963 · S/N 18254643 N3243XPowell Kenneth D · Benton, ARFirst renewal noticeBuilt 1966 · S/N 15064643 N3244APrevail Aviation LLC · Hurley, WIBuilt 1953 · S/N 25888 N3244DBrooks Laura · Palmer, AKBuilt 1955 · S/N 32042 N3244LKyzer Aviation Holdings LLC · Fort Mill, SCBuilt 1967 · S/N 17256144 N3244TCaicedo Oscar E · Garner, NCS/N 17700544 N3244XStecks Keith A · Vista, CABuilt 1966 · S/N 15064644 N3244YCutrell William J · Mc Donald, TNBuilt 1962 · S/N 18254244 N3245AMoseley Deborah M · Homer, AKBuilt 1953 · S/N 25889 N3245GDougherty Robert E · Mosheim, TNBuilt 1956 · S/N 28326 N3245JAll Sports Aviation LLC · Spokane, WABuilt 1966 · S/N 15065945 N3245LGift Academy Inc · Vernon, TXBuilt 1967 · S/N 17256145 N3245XSchneider Alex · Tempe, AZS/N 15064645 N3246DJaden H Erwin Dds Pllc · Helena, MTBuilt 1955 · S/N 32044 N3246EKauffman Gerald E · Bedford, PABuilt 1982 · S/N 18268239 N3246LStephens David J · Clarence, NYBuilt 1967 · S/N 17256146 N3246TFears Edwin G III · Trafalgar, INBuilt 1967 · S/N 17700546 N3246UGregory Group LLC · Norwalk, CTBuilt 1963 · S/N 18254646 N3246XRouns Daniel L · Brady, MTBuilt 1966 · S/N 15064646 N3247TBeeda Mark A · West Palm Beach, FLBuilt 1967 · S/N 17700547 N3247VHentschel Ernest J · Galloway, NJS/N 15076440 N3248DPalmer Cade E · Eagle River, AKBuilt 1955 · S/N 32046 N3248SHanson Glen W · Anchorage, AKBuilt 1964 · S/N 18255748 N3249UHutchison Roger R · Sioux Falls, SDBuilt 1963 · S/N 18254649 N324FFMason Michael A · New Carlisle, INBuilt 1969 · S/N A1500142 N324LULetourneau University · Longview, TXS/N 15067538 N324RHPhillips William L Trustee · E Hampton, MABuilt 1979 · S/N 18267211 N324RJSchelhorn Timothy J · Nampa, IDS/N 18254601 N324SVDavis Kyle R · Colleyville, TXBuilt 1980 · S/N R18201609 N324YCesscon LLC · Yalesville, CTBuilt 1976 · S/N 18264524 N3250JHigh Mesa Aviation LLC · Naturita, COBuilt 1966 · S/N 15065950 N3250LMiner Jess L · Emmet, NEBuilt 1967 · S/N 17256150 N3250U50 Uniform LLC · Traverse City, MIBuilt 1963 · S/N 18254650 N3250YEonm182 LLC · El Paso, TXBuilt 1962 · S/N 18254250 N3251DE S P Aviation LLC · Wilmington, DES/N 32049 N3251LWiles David A · Ozark, ARBuilt 1967 · S/N 17256151 N3251YCarlson Andrew J · Ashville, NYBuilt 1962 · S/N 18254251 N3252ABuddenberg Bradford C · Anchorage, AKBuilt 1953 · S/N 25896 N3252DQuigg Aircraft LLC · Muskegon, MIBuilt 1955 · S/N 32050 N3252LElizabethton Aerobatic Club Inc · Elizabethton, TNS/N 17256152 N3252SWhite Robert E · Woodlawn, TNBuilt 1964 · S/N 18255752

Back to AD 87-20-03 R2