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.

N2193VApm Leasing LLC · Casper, WYBuilt 1979 · S/N 44-7995266 N2194DAir Repair Inc · Easton, MDBuilt 1953 · S/N D-3541 N2194GMeyer Wayne G · Bozeman, MTBuilt 1958 · S/N 51494 N2194KAviation Training LLC · Wilmington, DEBuilt 1978 · S/N 44-7995203 N2194RJacobson Aviation LLC · Hannibal, MOBuilt 1964 · S/N 18255394 N2194SUziel Yehoram · Northridge, CAS/N R18201312 N2194TNelson Donald M Jr · Fair Oaks, CABuilt 1971 · S/N 28-7205045 N2194YDavid Shawn M · Roscoe, ILBuilt 1979 · S/N 28R-7931149 N21950Cousins Mark T · Portland, ORS/N 17264046 N21956Lake Elmo Flyers LLC · Vadnais Heights, MNBuilt 1974 · S/N 17264048 N21958Hillsboro Aero Ltd · Hillsboro, NDBuilt 1976 · S/N 18503072 N2195DMauldin Gary W · Navajo Dam, NMBuilt 1953 · S/N D-3542 N2195EZameroski Daniel C · Mckean, PABuilt 1978 · S/N 28-7990182 N2195FRobinson Tracy · Veneta, ORBuilt 1965 · S/N U206-0395 N2195LGinsberg Andrew P · Rochester, NYBuilt 1979 · S/N 28R-7918032 N2195MKorba Sean · San Jose, CABuilt 1979 · S/N 28-7911090 N2195PZahlmann Daniel R · Queen Creek, AZS/N 23-803 N2195RMclean Laura A · Palmer, AKS/N 18255395 N2196DWilewski Clifford R · Freeport, ILBuilt 1953 · S/N D-3543 N2196NThompson Kurt C · Rochester, MNBuilt 1979 · S/N 32-7940037 N2196RStonebrink Melvin D · Wallowa, ORBuilt 1964 · S/N 18255396 N2196TTilly Curtis L · Raleigh, NCBuilt 1971 · S/N 28-7205047 N2196VFixed Wing Holding Co Inc · Pembroke Pines, FLBuilt 1979 · S/N 44-7995267 N2196YKoelbl Aviation LLC · Whitesboro, TXBuilt 1962 · S/N 17249696 N2196ZAnderson Randy · Brantingham, NYBuilt 1963 · S/N 18051296 N2197DKaiser Aviation LLC · Newman, ILBuilt 1953 · S/N D-3544 N2197GBreshears Jason N · Cameron, MOBuilt 1958 · S/N 51497 N2197LJ Rougeau Rehab Inc · North Adams, MABuilt 1976 · S/N TC-2018 N2197TAdams Donald L · Huntsville, ALBuilt 1971 · S/N 28-7205048 N2197YWeber Raymond E · Palmer, AKBuilt 1962 · S/N 17249697 N21985N21985 LLC · Deltona, FLBuilt 1978 · S/N 28-7990066 N2198GAirstar Aviation Inc · Chester, SCBuilt 1958 · S/N 51498 N2198PAerotrack Inc · Hemet, CABuilt 1956 · S/N 23-808 N2198ROlson Darryld A · Buckley, WAS/N 18255398 N2198SPeavey Brian H · Houston, TXBuilt 1979 · S/N R18201314 N2198YCustard Ray · Houston, TXBuilt 1962 · S/N 17249698 N21992Gilpin Sean F · Madison, ALBuilt 1978 · S/N 32R-7885265 N2199CMorris Thomas B · Imlay City, MIBuilt 1958 · S/N 38081A N2199GEmery Craig A · Wasilla, AKBuilt 1958 · S/N 51499 N2199HQualitair LLC Trustee · MichelstadtBuilt 1978 · S/N 28R-7931005 N2199KRegistered aircraftBuilt 1951 · S/N D-2941 N2199LCardamone-Rayner Mark · Manistique, MIBuilt 1976 · S/N E-968 N2199PPowers Edward · Stormville, NYS/N 23-809 N2199TKeith Brothers Aviation LLC · Fort Worth, TXBuilt 1971 · S/N 28-7205051 N219AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843788 N219BYoungs William D Jr · Moravia, NYBuilt 1956 · S/N D-4522 N219BJTaylor Kennedy E · Courtland, MSBuilt 1967 · S/N 28-22813 N219BTDacy Justin A · Boerne, TXBuilt 1976 · S/N 21061568 N219CHSteel Eagle Aviation LLC · Birmingham, ALBuilt 2001 · S/N TH-1990 N219DBN219db LLC · Bryan, OHBuilt 1966 · S/N 28-2970

Back to AD 98-21-21 R1