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.

N5405MToozer Air LLC · Ormond Beach, FLBuilt 1980 · S/N 15284581 N5405RPolson Taylor M · Killeen, TXBuilt 1965 · S/N 17252943 N5405TAgt Tech Corp · Hialeah, FLNon-citizen corporation, flight hours not reportedS/N 17251305 N5405VVidal Aviation LLC · Gaithersburg, MDBuilt 1977 · S/N R1722294 N54067St Pete Aviation Services LLC · Saint Petersburg, FLS/N 17274866 N5406CGugel Joseph J · Wasilla, AKBuilt 1950 · S/N 19440 N5406RMmm Enterprises LLC · Aurora, INBuilt 1965 · S/N 17252945 N54073Center O Flying Club · Tumwater, WABuilt 1981 · S/N 17274868 N54079Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17274869 N5407BSutton Aircraft Salvage LLC · Palmer, AKS/N 33407 N5407QR G V Flight Academy LLC · Bayview, TXS/N 15073307 N5407RLake Area Technical College · Watertown, SDS/N 17252946 N5408BLeonard James A · Boise, IDBuilt 1956 · S/N 33408 N5408ECutbirth Henry R · Monahans, TXBuilt 1978 · S/N 17271846 N5408HSchmidt Kelly D · Lake Elmo, MNBuilt 1975 · S/N 17265427 N5408NAviation Law LLC · Mesa, AZBuilt 1980 · S/N 18267694 N5408RRegistration Pending · Brookland, ARRegistration pendingBuilt 1974 · S/N 17263536 N54093Kamenev Alexey · Hinsdale, ILS/N 17274873 N54094Mustang Sally Aviation LLC · Camden, SCBuilt 1981 · S/N 17274874 N5409JKelley Aircraft LLC · Weyers Cave, VABuilt 1980 · S/N 17273782 N5409QOwens Anthony G · Kotzebue, AKS/N 15073309 N5409RMclane Tucker · Newton, MABuilt 1974 · S/N 17263537 N5409TSchein Joshua A · Anchorage, AKBuilt 1964 · S/N 17251309 N5409YLee Christopher · Katy, TXBuilt 1980 · S/N 21064198 N540CEEverel Airborne LLC · Sandia Park, NMBuilt 1985 · S/N P21000853 N540DHoopes Kristopher · Davis, OKBuilt 1959 · S/N 55907 N540RTMorgan Stanley L · Nome, AKS/N 52-118 N54102Adriatic Holdings LLC · Cheyenne, WYBuilt 1981 · S/N 17274875 N54108Lawson Troy · Kettle Falls, WABuilt 1981 · S/N 17274877 N5410BOklahoma Soaring Association · Mustang, OKBuilt 1956 · S/N 33410 N5410RIsbell Thomas · Mountain View, ARBuilt 1965 · S/N 17252950 N54115Mang Aero Club Inc · Belleville, MIBuilt 1981 · S/N 17274879 N5411AMarc Aircraft Holding LLC · Soldotna, AKBuilt 1979 · S/N 21063422 N5411BBailey Carl D · Huntington, WVBuilt 1956 · S/N 33411 N5411HEarth Grazer Inc · Homer Glen, ILBuilt 1975 · S/N 17265428 N5411TTioga Land Development LLC · Tioga, NDBuilt 1964 · S/N 17251311 N5411XUsda Aphis Ppq · Edinburg, TXBuilt 1980 · S/N U20605727 N54120Carastro Enterprises LLC · Montgomery, ALBuilt 1981 · S/N 17274884 N5412ESierra Skywagons LLC · Helena, MTBuilt 1979 · S/N 18503966 N5412NCat Claw Aviation LLC · San Antonio, TXBuilt 1980 · S/N 18267763 N5412QWilson William W · Mccall, IDBuilt 1972 · S/N 15073312 N5412RYoungstown Warren Development Partners · Youngstown, OHS/N 17252953 N5412SBarrett E James · Queensbury, NYBuilt 1980 · S/N R18201567 N5412TBartlomiej Gadaj · Jacksonville, FLBuilt 1964 · S/N 17251312 N5412VG & M Aircraft Inc · Wheat Ridge, COBuilt 1980 · S/N 172RG0524 N54135Aviation Professionals Inc · Chicago, ILS/N 17274886 N5413RMckee Thomas E · Terra Alta, WVBuilt 1965 · S/N 17252954 N5413TLrp Aircraft LLC · Durham, NCBuilt 1964 · S/N 17251313 N54141Traverse City Helicopters LLC · Traverse City, MIBuilt 1981 · S/N 17274888 N54148Strickland John J · Atlanta, GABuilt 1981 · S/N 17274889

Back to AD 87-20-03 R2