Skip to content

Registered aircraft · 85,620

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.

N2232NKnoll Guenter Wilhelm · Belton, SCBuilt 1979 · S/N 28-7990283 N2232QStender Michael L · Davenport, IABuilt 1979 · S/N 28-7911106 N2232WJkj Aviation · Wilmington, NCBuilt 1979 · S/N 28-7916334 N2232ZAlaverdi Omeed · California, MDBuilt 1976 · S/N 76-31135 N22334Fredericks Hall Aviation LLC · Mineral, VABuilt 1977 · S/N TE-1111 N22336Goldshlager Benjamin · Boca Raton, FLBuilt 1978 · S/N 28-7911004 N2233BRollin Virginie C · Mountain House, CABuilt 1978 · S/N 28-7816598 N2233CFreeland Robert D · Victor, MTBuilt 1978 · S/N 28-7990147 N2233DMerrill Christopher D · Albany Twp, MES/N 20385 N2233GA F Flyers LLC · American Falls, IDBuilt 1958 · S/N 51533 N2233LBecker Leo Henry · Leavenworth, KSBuilt 1979 · S/N 32-7940028 N2233PAeroplanes Over Idaho · Caldwell, IDS/N 23-842 N2233RDorman William James Trustee · Anchorage, AKBuilt 1975 · S/N 18502859 N2233SRichardson Robert O · Spring Grove, ILBuilt 1976 · S/N 21061178 N2233TSeward Air Taxi LLC · Seward, AKS/N 185-1386 N2233WMiloud Chadd K · Fort Worth, TXS/N 28-7916335 N2233XSpector Arnold · Stamford, CTBuilt 1979 · S/N 28-7990368 N2234FMoore Aviation LLC · Cedar Springs, MIBuilt 1978 · S/N 28-7990207 N2234GBaldwin Trevor K · Owasso, OKBuilt 1958 · S/N 51534 N2234RJones Lennis William III · Rule, TXBuilt 1968 · S/N T210-0384 N2235BConner W Larry · Los Lunas, NMBuilt 1978 · S/N 28-7916120 N2235CAnderson Nick A · Cynthiana, KYBuilt 1978 · S/N 28-7911024 N2235DHasner Mark A · Fairbanks, AKS/N 20387 N2235ELivingston Eric L DBA · Winchester, INBuilt 1978 · S/N 17271198 N2235SN2235s LLC · Overland Park, KSBuilt 1976 · S/N 21061180 N2235WSamuels Walter E · Wilmington, NCBuilt 1969 · S/N 30-1844 N2235ZWilson James F Jr · Williamstown, KYS/N 28-7921021 N22363Barnes Welding Inc · Waterville, WABuilt 1978 · S/N 32R-7887258 N2236CAlexander James E Jr · Fort Worth, TXBuilt 1978 · S/N 28-7911025 N2236GParis Air Inc · Vero Beach, FLBuilt 1978 · S/N 28-7916215 N2236MC6 Aviation LLC · Hoboken, NJBuilt 1977 · S/N 32R-7880054 N2236PCitation X Parts LLC · Liberty, NCBuilt 1956 · S/N 23-845 N2236RSouthern Skies Aviation Inc · Cedar City, UTS/N T210-0386 N2236TParks Walter G · Chugiak, AKBuilt 1968 · S/N 185-1390 N2236WMiloud Chadd K · Fort Worth, TXBuilt 1979 · S/N 28-7916337 N2236ZRoukema James E · Pueblo, COBuilt 1979 · S/N 28-7921022 N22370Top Flight Sales Inc · Wilmington, DEBuilt 1978 · S/N 32R-7887259 N2237AKimber 123 Holdings LLC · Morgantown, WVBuilt 1978 · S/N 32R-7987016 N2237GSmith Caleb · Beggs, OKBuilt 1958 · S/N 51537 N2237KCarolina Air LLC · New London, NCBuilt 1978 · S/N 28-7916232 N2237QJenkins John E Jr · Long Valley, NJBuilt 1979 · S/N 28-7911107 N2237TSchmelzle Michael O · Shrewsbury, MOBuilt 1979 · S/N 28-7916302 N2238CGorham Wendy J · Grand Rapids, MNBuilt 1953 · S/N 30538 N2238DFanoni Michael A · Colfax, CABuilt 1952 · S/N 20390 N2238EAtd Pilot Training LLC · Kansas City, MOS/N 17271199 N2238GRupp Aviation LLC · O Fallon, MOBuilt 1979 · S/N 28-7990418 N2238HRhodes Mike A · Independence, ORBuilt 1953 · S/N 25644 N2238ZHaines Ranch · White Lake, SDBuilt 1979 · S/N 28-7921024 N22395Morrison Donald D · Santa Clarita, CABuilt 1974 · S/N 17264063 N22396Jordan Lennon D · Bartow, FLBuilt 1972 · S/N 21059741

Back to AD 98-21-21 R1