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.

N2674LValley Excavation And Grading Inc · Chatsworth, CABuilt 1967 · S/N 17255874 N2674VMoroil Corp · Davidson, NCBuilt 1974 · S/N 177RG0651 N2674XKaiser Eric J · Milford, INBuilt 1966 · S/N P206-0174 N2675DPaige Barry Wayne · Wasilla, AKBuilt 1952 · S/N 20827 N2675FVarnado Matthew G · Denham Springs, LABuilt 1965 · S/N 18256775 N2675LFoster Jeffrey W · Lexington, NCBuilt 1967 · S/N 17255875 N2675RDotzenroth David A · Watertown, MNS/N 185-02392 N2675UAv Hawk Aviation LLC · Montclair, NJS/N 17250275 N2675VHartis Christopher · Newman Lake, WABuilt 1948 · S/N 18185 N2676DLamott Brenda I · Boise, IDBuilt 1952 · S/N 20828 N2676GHolland Ross D · Guymon, OKBuilt 1959 · S/N 51976 N2676KFurey Michael J · Hazlehurst, MSS/N 18053033 N2676LCupp Stanley J · Quilcene, WABuilt 1967 · S/N 17255876 N2676URobinson Dalton M · Londonberry, OHS/N 17250276 N2677FNeu Aviation LLC · Benton, LABuilt 1965 · S/N 18256777 N2677GPeterson Barbara A · Cheney, KSBuilt 1959 · S/N 51977 N2677KAeropod Inc · Aurora, COS/N 18053034 N2677XHawk Jeff · Flowermound, TXBuilt 1965 · S/N P206-0177 N2677YHracha Deanna L · Palmer, AKBuilt 1963 · S/N 18051177 N2678SHardy Mikel Gareth · Thatcher, AZBuilt 1973 · S/N 18502265 N2678XStewart Jeffrey D · Snyder, TXBuilt 1965 · S/N P206-0178 N2679DHoppe Air LLC · Beaman, IABuilt 1952 · S/N 20831 N2679FR & K Explorations Inc · Bonners Ferry, IDBuilt 1966 · S/N 18256779 N2679JJupiter Flight Service And Investing LLC · Lithonia, GABuilt 1966 · S/N 15065679 N2679LBartley James K · Kent, WABuilt 1967 · S/N 17255879 N2679RSchultz Charles D · Webster, WIBuilt 1967 · S/N 18258379 N2679SJordan Richard L · Memphis, TNBuilt 1968 · S/N 337-0979 N2679ZRonalter John M · Norristown, PABuilt 1963 · S/N 185-0679 N267EEvenson Charles R · Saint Charles, MOBuilt 1972 · S/N 15074092 N267LMAviation Trust Co LLC Trustee · Oklahoma City, OKBuilt 1979 · S/N P21000362 N267RAReynolds Darryl G · Wills Point, TXS/N 17261919 N2680FWatkins Jeffrey M · Auburn, CABuilt 1965 · S/N 18256780 N2680GTodd Larry D · Wasilla, AKBuilt 1959 · S/N 51980 N2680YReid Brian M · Boise, IDBuilt 1962 · S/N 18051180 N2681GRhea Higher Education And Aviation LLC · Prescott, AZBuilt 1959 · S/N 51981 N2681SBromley Keith W · Titusville, PAFirst renewal noticeS/N 337-0981 N2681UOsterhaus Jonathan · Petersburg, TNBuilt 1963 · S/N 17250281 N2681XZimmer Roy E Jr · Winter Park, FLBuilt 1965 · S/N P206-0181 N2682GFlying L Aircraft Inc · Fort Denaud, FLBuilt 1959 · S/N 51982 N2682JCooper David J · Gravette, ARBuilt 1966 · S/N 15065682 N2682LCommonwealth Technical Services Inc · Powhatan, VABuilt 1967 · S/N 17255882 N2682RRadeka Michael · East Machias, MES/N 18258382 N2682UCseh Sandor · New Brunswick, NJBuilt 1963 · S/N 17250282 N2682VVogen Jeffrey L · Newark, ILBuilt 1948 · S/N 18193 N2683CGrigg Charles G · Pasco, WABuilt 1978 · S/N R18200211 N2683DRasmussen Merlin P · Enumclaw, WABuilt 1952 · S/N 20835 N2683GEtc Aircraft LLC · Anchorage, AKFirst renewal noticeS/N 51983 N2683RNance James H II · Grants Pass, ORBuilt 1967 · S/N 18258383 N2683VPeters Robert M · Fremont, INBuilt 1975 · S/N 177RG0655 N2684DSaltsgaver Robert E III · Maryville, TNS/N 20836

Back to AD 87-20-03 R2