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.

N2497YSouth Plains Precision Ag · Plainview, TXBuilt 1962 · S/N 17249797 N2498FTaylor Andrew A · Ketchikan, AKBuilt 1966 · S/N 18051700 N2498GKc Aircraft LLC · Missoula, MTBuilt 1959 · S/N 51798 N2498LJohn Kit M · Shoshone, IDBuilt 1966 · S/N 17255698 N2498RJohnson Christopher A · Pampa, TXBuilt 1964 · S/N 18255598 N2498SKatz Michael R Trustee · Merritt Island, FLBuilt 1976 · S/N 21061306 N2498URegistration Pending · Royal, ARRegistration pendingBuilt 1963 · S/N 17250098 N2498XVotava Paul A · Mcintosh, MNBuilt 1965 · S/N 18256398 N2498YBargabos Earthworks Inc · Peterboro, NYBuilt 1962 · S/N 17249798 N2499QLand Phillip R · Hartford, WIBuilt 1977 · S/N 28-7725197 N2499YTompos Michael J · Mendota Heights, MNBuilt 1962 · S/N 17249799 N249ASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1977 · S/N CJ132 N249BB42m Aviation LLC · Shady Shores, TXBuilt 1979 · S/N D-10318 N249CBCalifornia Baptist University · Riverside, CABuilt 2023 · S/N 2881636 N249CRA&W Air LLC · Aiken, SCBuilt 1979 · S/N TJ-249 N249DMAnderson Spencer D · Lafayette, LAS/N 2514 N249EABertsch Paul J · Houston, TXBuilt 1962 · S/N D-7051 N249JAEagle Aviation LLC · Indianapolis, INBuilt 2021 · S/N 28020028 N249MDMorrison William F · Athol, IDBuilt 1965 · S/N 18051501 N249MGGeorgia Aviation Authority · Eastman, GABuilt 2024 · S/N 2881712 N249MVAmble Tod M · Bozeman, MTBuilt 1979 · S/N CE-884 N249NDPlane Nonsense Inc · Middletown, DEBuilt 1999 · S/N 2842059 N249NYWoldt Wayne E · Raymond, NEBuilt 1978 · S/N 17271032 N249SPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1975 · S/N 21060990 N249TJF Korbel & Bros · Guerneville, CABuilt 1966 · S/N TE-249 N249WKz805 LLC · Wilmington, DES/N 34-7770312 N249WFWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 1976 · S/N 28-7690114 N249WHWhiskey Hotel LLC · O Fallon, MOBuilt 1978 · S/N CJ-147 N249WLSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N CJ-134 N249YJohnson Steven A · New Braunfels, TXBuilt 1969 · S/N CE-282 N24AAGentry Robert L · Tyler, TXFirst renewal noticeBuilt 1955 · S/N D-4285 N24AGAegis Air LLC · Columbia City, INBuilt 1979 · S/N D-10293 N24AKLund Kristoffer B · Encinitas, CABuilt 1968 · S/N TC-1150 N24APMartinelli John P · Cumberland, RIBuilt 1973 · S/N 28-7305199 N24ASRegistered aircraftBuilt 1985 · S/N E-2259 N24BEMystic Knights Of The Air Lodge Inc · Canton, MSBuilt 1979 · S/N E-1540 N24BFWright Aviation Inc · Pikeville, KYBuilt 1980 · S/N E1736 N24BKN24bk LLC · Jupiter, FLBuilt 1977 · S/N E-1145 N24BPMiller Dwayne C · Comanche, TXBuilt 1956 · S/N 32939 N24BSSiemers Warren G · Fort Collins, COBuilt 1967 · S/N 670495 N24CHDagostini Robert A · Mount Aukum, CABuilt 1975 · S/N 21060793 N24CJAtluas LLC · Anna, TXS/N 18502199 N24CKAir Travel Management LLC · Lemont Furnace, PABuilt 1975 · S/N 31-7512049 N24CSMcmanigle Jeffrey · Osakis, MNBuilt 1975 · S/N 76-30804 N24CVPacific Air Flight School LLC · Long Beach, CABuilt 1977 · S/N 17270186 N24ELDye Eric M · Winters, CABuilt 1979 · S/N R18200884 N24FWatkins Brian · Los Alamos, NMS/N 18266495 N24FGCalifornia Department Of Fish And Game · Sacramento, CABuilt 1981 · S/N 18504207 N24FLHill Steven D · Carroll, IABuilt 1964 · S/N 28-1790 N24GCGreene County Sports Parachute · Loretto, KYBuilt 1954 · S/N 31163

Back to AD 98-21-21 R1