Registered aircraft · 54,019

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.

N2467DKaras Alyssa · Henderson, NVBuilt 1952 · S/N 20619 N2467FTherkelsen Robert D · Burlington, WABuilt 1966 · S/N 18051669 N2467GShort David J · Warrensburg, MOBuilt 1959 · S/N 51767 N2467JHenderson Samuel · Wasilla, AKS/N 15065567 N2467LPatton Michael D · Tygh Valley, ORBuilt 1966 · S/N 17255667 N2467RSparks Eric D · Missouri Valley, IABuilt 1964 · S/N 18255567 N2468BRegistered aircraftBuilt 1970 · S/N 18260274 N2468CHatley Ralph A · Eagle Creek, ORBuilt 1954 · S/N 30768 N2468EUrbany Mark A · Hickory, PABuilt 1978 · S/N 17271294 N2468LCavender Kevin S · Tucson, AZBuilt 1966 · S/N 17255668 N2468RCruson Dale E Trustee · Ontario, ORBuilt 1964 · S/N 18255568 N2468URegistration Pending · Washington, WVRegistration pendingBuilt 1963 · S/N 17250068 N2469DPierce Jerri L · Ozona, TXBuilt 1952 · S/N 20621 N2469MDillehay David Lynn · League City, TXBuilt 1973 · S/N 15075201 N2469QKepler Jason M · Wasilla, AKBuilt 1966 · S/N 18257669 N2469RKrehbiel Doug W · Moscow, IDBuilt 1964 · S/N 18255569 N2469XFraulini Michael M · Franklin Furnace, OHBuilt 1965 · S/N 18256369 N2469YStanphill David L · Stephenville, TXBuilt 1962 · S/N 17249769 N246BCKeystone Solutions LLC · Higley, AZS/N 18259539 N246BTGentile Keith · Riverton, UTBuilt 1967 · S/N 337-0769 N246CCAlaska Department Of Public Safety · Anchorage, AKBuilt 1979 · S/N U20605314 N246ECKnight Air LLC · Wausau, WIS/N 21062435 N246JJlr Resources LLC · Naples, FLBuilt 1979 · S/N P21000355 N246KWGenellie Gerald F Jr Trustee · Batavia, OHBuilt 1980 · S/N 18267659 N246LSJohnson Mark · Macon, MSS/N 32185 N246PAHugie Lucas R · Logan, UTS/N 18257487 N246SPWingsleasing LLC · Wichita, KSBuilt 1977 · S/N 17269023 N246TRegistered aircraftBuilt 1981 · S/N 18268091 N246TFMorgan Daniel D · Topeka, KSS/N R18201677 N246VTAkwe River Flying And Guide Service LLC · Yakutat, AKBuilt 1975 · S/N U20602822 N24708Spartan Education LLC · Tulsa, OKBuilt 1977 · S/N 15280332 N2470CMcclymond Tyler L · Grand Junction, COS/N 30770 N2470GBaillargeon Richard W · Springville, IABuilt 1959 · S/N 51770 N2470LSmith Joseph · Sycamore, ILBuilt 1966 · S/N 17255670 N2470QCities Aviation Services LLC · Dubberly, LABuilt 1966 · S/N 18257670 N2470UT C I Aviators LLC · Lewes, DEBuilt 1963 · S/N 17250070 N24714Bourne Randy D · Orting, WABuilt 1977 · S/N 15280334 N2471CCavjet LLC · Bonham, TXBuilt 1954 · S/N 30771 N2471EWilliams Stephen H · Phoenix, AZBuilt 1982 · S/N 18268206 N2471JKrisch Garry A · Kenedy, TXBuilt 1966 · S/N 15065571 N2471QThomas Salvatore J · Lenoir City, TNBuilt 1966 · S/N 18257671 N2471RFykerud Eric J Sr · Bend, ORBuilt 1964 · S/N 18255571 N2471YRegistered aircraftBuilt 1962 · S/N 17249771 N24725Technical Education Services Inc · Virginia Beach, VABuilt 1977 · S/N 15280341 N2472FParr Crawford B · Anchorage, AKBuilt 1966 · S/N 18051674 N2472JDolev Eyal · Portland, ORBuilt 1977 · S/N 15279969 N2472QSalzman Denise M · Cameron Park, CABuilt 1966 · S/N 18257672 N2472RVac New Inc · China Village, MENon-citizen corporation, flight hours not reportedBuilt 1964 · S/N 18255572 N2472XPhillips Robert Frank · Tabernacle, NJBuilt 1965 · S/N 18256372 N2473CLewis Eddy L · Cortez, COBuilt 1954 · S/N 30773

Back to AD 87-20-03 R2