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.

N2646VEsslinger David F · Zionsville, INBuilt 1948 · S/N 18156 N2647FGayneaux Kelly J · Midland, TXS/N 18256747 N2647GAllen Steven L · Thatcher, AZBuilt 1959 · S/N 51947 N2647KBoice Petroleum Consulting LLC · Pinedale, WYS/N 18053025 N2647LCommonwealth Aviation Services LLC · Herndon, VABuilt 1967 · S/N 17255847 N2647RSaber Wings LLC · Sacramento, CABuilt 1967 · S/N 18258347 N2648FLincoln Sport Parachute Club Inc · Lincoln, NEBuilt 1965 · S/N 18256748 N2648LZangs William J · Poplar Grove, ILBuilt 1967 · S/N 17255848 N2648QBuck Irrigation Inc · Elkhart, KSBuilt 1966 · S/N 18257848 N2648URock Kenneth L · Petersburg, AKBuilt 1963 · S/N 17250248 N2648WDeghetto Richard D · Hopkinsville, KYBuilt 1966 · S/N 981 N2648YSw Aviation Services Inc · Queen Creek, AZBuilt 1955 · S/N 31676 N2649FSkylane 2649f LLC · Kalispell, MTBuilt 1965 · S/N 18256749 N2649GSwanson Gregory N · Meridian, IDS/N 51949 N2649RShah Aitazaz · Shady Shores, TXBuilt 1967 · S/N 18258349 N2649UMorrison Kent · Mccleary, WAFirst renewal noticeBuilt 1963 · S/N 17250249 N2649VStedingh Donald M · Anchorage, AKBuilt 1948 · S/N 18159 N2649WTeeter Joseph Jerald · Lisbon, OHBuilt 1966 · S/N 982 N2649XK-Mcj Equipment LLC · Longview, TXS/N P206-0149 N264AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881759 N264ATAirline Transport Prof Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496088 N264CAChoice Aviation LLC · Hamilton, MTBuilt 1975 · S/N 17266035 N264CTDouglass Joyce M · Christiansburg, VABuilt 1978 · S/N 17270716 N264DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843825 N264DHPolymath Enterprises LLC · Incline Village, NVBuilt 1981 · S/N 32R-8129095 N264FAStratus Rr LLC · New Castle, DEBuilt 2026 · S/N 28020260 N264GCon-Air Aviation LLC · Queen Creek, AZBuilt 1967 · S/N 30-1633 N264JGSparkling Diamond LLC · Middleton, WIBuilt 1999 · S/N E3264 N264MSanterre Phillip E Trustee · Chugiak, AKBuilt 1958 · S/N 50236 N264MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881362 N264NDPars Avn Corp · Wilmington, DEBuilt 2000 · S/N 28-42069 N264QChan Hung-Chun · Orem, UTBuilt 1966 · S/N TC-987 N264SASundance Airport LLC · Yukon, OKBuilt 1968 · S/N 28-25258 N264SBCkw Aviation LLC · Dalhart, TXS/N TE-1125 N264SWBuilding Materials Supply Inc · Yakima, WABuilt 1998 · S/N E-3190 N2650DBrekke Aviation Inc · Edmore, NDBuilt 1952 · S/N 20802 N2650FFlight Time LLC · Highland, MIBuilt 1966 · S/N 18256750 N2650GNewkirk Kevin J · Manhattan, KSS/N 51950 N2650LRholetter Eric W · Westminster, SCBuilt 1967 · S/N 17255850 N2650WBrown Danny L · Wichita, KSS/N 983 N2651FMars Aviation LLC · Commerce City, COBuilt 1965 · S/N 18256751 N2651LJohnson Turner C II · England, ARBuilt 1967 · S/N 17255851 N2651WStolworthy Spencer D · Maple Valley, WABuilt 1966 · S/N 3307 N2652DScheidler Jerome P · Greensburg, INBuilt 1952 · S/N 20804 N2652FMartindale Lloyd M · Bellingham, WABuilt 1965 · S/N 18256752 N2652LSullivan James M · East Wakefield, NHBuilt 1967 · S/N 17255852 N2652RDevries Francis P · Justin, TXBuilt 1967 · S/N 18258352 N2652THart William · West Plains, MOBuilt 1971 · S/N 28-7205063 N2652WRegistered aircraftBuilt 1966 · S/N 3308 N2653FBagstad Lance · Park Rapids, MNBuilt 1965 · S/N 18256753

Back to AD 98-21-21 R1