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.

N1317TWhite Tavon L · Stockbridge, GABuilt 1972 · S/N 28-7225461 N1317ULondondeery Flying Club Inc · Litchfield, NHBuilt 1976 · S/N 17267006 N1317WMorgenfeld Thomas A · Camarillo, CABuilt 1963 · S/N 205 N13182Spillman Aviation LLC · Colorado Springs, COBuilt 1973 · S/N 17262552 N13185Good Flight LLC · Colchester, CTBuilt 1973 · S/N 17262554 N13187Fly Aviation Corp · Wilmington, DES/N 17262556 N1318DBott Christopher L · Pilot Point, TXBuilt 1951 · S/N 19894 N1318HEvern Properties LLC · Kalispell, MTS/N 28R-7703022 N1318PDye Paul C · Mc Neal, AZBuilt 1965 · S/N 185-0871 N1318TAire-Drifter LLC · Staten Island, NYS/N 28-7205280 N13190Donham Rita M · Cora, WYBuilt 1973 · S/N 17262559 N13196Frederick Christopher N · North Mankato, MNBuilt 1973 · S/N 17262563 N1319PCanter Russell L · Enterprise, KSBuilt 1955 · S/N 23-360 N1319UMarsh John E · Washington, DCS/N 17267008 N1319YWinston William F · Lake Stevens, WABuilt 1961 · S/N 17249019 N1319ZGood Steven D · Douglas, WYBuilt 1961 · S/N D-6757 N131AGWings Over Texas Holdings LLC · Denton, TXBuilt 2024 · S/N 4496589 N131BMillspaugh John · Weatherford, OKBuilt 1955 · S/N D-4436 N131CACoast Flight Training And Management Inc · San Diego, CABuilt 2020 · S/N 2881353 N131DDLife Investors Aviation LLC · Milwaukee, WIBuilt 1982 · S/N D-10393 N131ELantz Herman D · Saint Clairsville, OHBuilt 1955 · S/N 31806 N131FHappy Star LLC · Baxley, GABuilt 1963 · S/N TC-538 N131FAJones Donald T Jr · Barrigada, GUBuilt 1968 · S/N 27-4097 N131JDMccurry Patty Trustee · Ocala, FLBuilt 1978 · S/N 17270668 N131LLAims Community College · Greeley, COBuilt 2020 · S/N 2881345 N131LRCharles City Aeronautics Inc · Charles City, IABuilt 1974 · S/N 28-7425258 N131MDWoodley Aerial Leasing LLC · Walnut, ILBuilt 1959 · S/N D-5978 N131MEDuncan John H Jr · Bend, ORBuilt 1984 · S/N TJ-451 N131MTWings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17262525 N131PAAmeriflyers Of Texas Inc · Addison, TXBuilt 2022 · S/N 28020055 N131PBTom Tatum Pa · Danville, ARBuilt 1975 · S/N 310R0514 N131PJCrosswinds Flight Center Inc · Drums, PAS/N 31-7912030 N131RJEggleston William A · Wayland, MABuilt 1974 · S/N 28-7415665 N131RMInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 27-7654053 N131TTCharlie Kilo Enterprises Inc · Melbourne, FLBuilt 1979 · S/N U20605010 N131TVO'Brien Daniel H · Half Moon Bay, CABuilt 1977 · S/N 27-7754070 N131TWBaron N131tw LLC · Wilmette, ILBuilt 1974 · S/N TE-963 N131YBeli Christopher J · Oregon, OHS/N 18052073 N13200Classic Aircraft Sales LLC · Weyers Cave, VABuilt 1973 · S/N 17262567 N13203Iowa Lakes Community College · Estherville, IABuilt 1973 · S/N 17262570 N13205Hoecher Robert T · Anchorage, AKBuilt 1973 · S/N 17262572 N13206Bishop Ronald E · Rolling Hills, CABuilt 1973 · S/N 17262573 N13208Thirty-Two Gulf Flying Club · Reston, VABuilt 1973 · S/N 17262575 N1320DHarlan Dale L · Big Lake, AKBuilt 1951 · S/N 19896 N1320SInternational Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 18264884 N1320WBas Part Sales LLC · Greeley, COBuilt 1963 · S/N 208 N1320YStc Aviation Inc · Saint Cloud, MNBuilt 1962 · S/N 17249020 N13211Robinson Rick J · Rocky Mount, MOBuilt 1973 · S/N 17262577 N13219Reboot Charity Inc · West Palm Beach, FLBuilt 1973 · S/N 17262584 N1321GInnovative Poultry Products LLC · Olar, SCBuilt 1976 · S/N 310R0701

Back to AD 98-21-21 R1