Registered aircraft · 85,616

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.

N1298RSouthern Utah University · Cedar City, UTBuilt 1972 · S/N 30479 N1298SHighlane LLC · Phoenix, AZBuilt 1976 · S/N 18264865 N1298ZShaw Aviation LLC · Greenleaf, IDBuilt 1961 · S/N D-6738 N12991Usda Forest Service Fepp · Columbia, SCBuilt 1973 · S/N 17262432 N12997Wausau Flying Service Inc · Wausau, WIS/N 17262437 N1299MMoanaviation Inc · Tampa, FLBuilt 1977 · S/N 21061932 N1299SAero Guard Aviation Insurance LLC · Lincoln, NEBuilt 1976 · S/N 18264866 N1299URice Melvin G · Bridgeport, TXBuilt 1976 · S/N 17266993 N1299XMunoz David · Corona, CAS/N 2680 N1299ZWojdac David E · Mosinee, WIS/N TD-467 N129ABPhilly Express LLC · Wilmington, DEBuilt 1994 · S/N EA-561 N129AGMarsh Equipment LLC · Aurora, ORBuilt 2024 · S/N 4496574 N129AHN388vr LLC · Olalla, WABuilt 1963 · S/N 17251051 N129ASPyxis Air LLC · Wilmington, DEBuilt 1976 · S/N 310R0663 N129AVCochran Jeffrey · Lincoln, NEBuilt 1980 · S/N 34-8070309 N129BTinney William G · Macon, GAFirst renewal noticeS/N D-4433 N129BMMain Gary Michael · Haverford, PABuilt 2004 · S/N E-3588 N129CMWoodhaven Air LLC · Blue Springs, MOBuilt 1958 · S/N 35625 N129CSGoldenstein Steven H Jr · Jurupa Valley, CABuilt 1975 · S/N 18264167 N129DPSplendid Air Leasing LLC · Corpus Christi, TXS/N 310L-0006 N129EEBuntings Grassroots Aviation LLC · Selbyville, DEBuilt 1977 · S/N CE-693 N129ELTrooien-Smith Construction LLC · Seeley Lake, MTBuilt 1978 · S/N U20604374 N129EWSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1973 · S/N 28R7335265 N129KTFowler Andy D · Anchorage, AKBuilt 1975 · S/N 18502812 N129LPJag Aviation LLC · Belle Chasse, LABuilt 1980 · S/N 18504088 N129MLarkin Marion J · Salome, AZBuilt 1973 · S/N 18502208 N129MAAttwood Nicholas John · Ashburn, VAS/N 2890219 N129MDMiller Glen S · Brenham, TXS/N 56430 N129MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2003 · S/N 4496172 N129PRRasmussen Paul B · Long Lake, NYBuilt 1968 · S/N 185-1448 N129QFlying J Aviation Pllc · League City, TXS/N TC-847 N129RJKenney Donill · Lake Worth, FLBuilt 1980 · S/N E-1752 N129SAero Quest LLC · Olive Branch, MSBuilt 1974 · S/N 17263118 N129SAUnlimited Vertical LLC · Milton Freewater, ORS/N 28R-7737053 N129SCSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 32-7440057 N129SLLee Aero LLC · Wichita, KSBuilt 1979 · S/N 17273503 N129STAzell LLC · Springfield, MOBuilt 1965 · S/N TC-835 N129SYDaigle Danny · Greenville, MEBuilt 1978 · S/N 17270741 N129TRDawson Aircraft Inc · Clinton, ARBuilt 1994 · S/N E-2888 N129VRecovery One Services LLC · Georgetown, KYBuilt 1979 · S/N 18267444 N129XSwarts Robert · Cincinnati, OHBuilt 1967 · S/N D-8586 N12ASNewman Scott W · Healdsburg, CABuilt 1973 · S/N 18502271 N12AVChambers Richard A · Sandpoint, IDFirst renewal noticeBuilt 1975 · S/N CE-603 N12AWTgam LLC · Toppenish, WABuilt 1978 · S/N U20604688 N12BTexacali Air LLC · Salado, TXBuilt 2001 · S/N E-3392 N12BCCentral Ohio Flyers Assn · Columbus, OHBuilt 1973 · S/N 18261895 N12BGFull Scale Aviation LLC · Mccordsville, INBuilt 1982 · S/N TC-2412 N12BJValentour Lance F · Naperville, ILBuilt 1974 · S/N 17264570 N12BRManning Richard F · Midway, GABuilt 1957 · S/N D-5391 N12BUVan Liew Bradford · Johns Island, SCBuilt 1968 · S/N TE-595

Back to AD 98-21-21 R1