Registered aircraft · 85,612

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:98-21-21-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1') 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:98-21-21-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1')
  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:98-21-21-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1')
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.

N2672YSchmieding Michael · Salem, ORBuilt 1962 · S/N 18051172 N26732Jefferies Jon F · Elk Grove Village, ILBuilt 1990 · S/N 90-301012 N2673GChapman Chad · San Antonio, TXBuilt 1959 · S/N 51973 N2673LBalcom Terry J · Shepherd, MIBuilt 1967 · S/N 17255873 N2673RDouville Laura Deluea · Portland, ORBuilt 1967 · S/N 18258373 N2673SWilliams Randall S · Chico, CABuilt 1976 · S/N 21061348 N2673TZweig William D · Chesterfield, MOBuilt 1972 · S/N 28-E11 N2673UBonin Patrick G · Blossvale, NYBuilt 1963 · S/N 17250273 N2673WAdolf Charles P · Ocala, FLBuilt 1966 · S/N 996 N2673ZFiske James K · North Andover, MABuilt 1963 · S/N 185-0673 N2674CTri County Sprayers Inc · Hamlin, TXBuilt 1955 · S/N 35074 N2674DKnefley Michael · Ulysses, PABuilt 1952 · S/N 20826 N2674LValley Excavation And Grading Inc · Chatsworth, CABuilt 1967 · S/N 17255874 N2674TCosgrove John W · Lake Ariel, PABuilt 1971 · S/N 28-7205075 N2674WHough Publishing LLC · Atlanta, GABuilt 1966 · S/N 997 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 N2675TMahoney Dustin G · Lakewood, COBuilt 1971 · S/N 28-7225084 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 N2676TMills Nicolas A · Greenwood, NYBuilt 1971 · S/N 28-7205074 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 N2677ST&D Janitorial Services LLC · Dexter, MOBuilt 1988 · S/N 89-301003 N2677TDaggett Truck Lines Inc · Frazee, MNBuilt 1971 · S/N 28-7205077 N2677WSaunders Charles A · Scott Depot, WVBuilt 1966 · S/N 3318 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 N2678TTekforce LLC · Boca Raton, FLBuilt 1971 · S/N 28-7205078 N2678WLansford Company Inc · Lampasas, TXBuilt 1966 · S/N 999 N2678XStewart Jeffrey D · Snyder, TXBuilt 1965 · S/N P206-0178 N2678ZKing Canyon Buffalo Inc · Denver, COFirst renewal noticeBuilt 1990 · S/N 90-301010 N26795Horan Roger · Plainview, TXBuilt 1992 · S/N 93-301015 N2679DHoppe Air LLC · Beaman, IABuilt 1952 · S/N 20831 N2679FR & K Explorations Inc · Bonners Ferry, IDBuilt 1966 · S/N 18256779 N2679LBartley James K · Kent, WABuilt 1967 · S/N 17255879 N2679QMorgan Jonathan P · Mooresville, NCBuilt 1977 · S/N 32R-7780260 N2679RSchultz Charles D · Webster, WIBuilt 1967 · S/N 18258379 N2679ZRonalter John M · Norristown, PABuilt 1963 · S/N 185-0679 N267AAWings Over Texas Holdings LLC · Denton, TXBuilt 2019 · S/N 4496482

Back to AD 98-21-21 R1