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.

N304MADodson International Parts Inc · Rantoul, KSBuilt 1997 · S/N 25-2004 N304ZBrickley Glendon R · Greenwood, SCBuilt 1960 · S/N CD-205 N3050ABlock Harlan T · Carthage, MOBuilt 1953 · S/N 25694 N3050DFly 8gs LLC · Pompano Beach, FLS/N 32R-7987059 N3050EDsi Limited Liability Corp · Blue Ridge, VABuilt 1978 · S/N 17271419 N3050KWalter Jones III Md Inc · Redlands, CABuilt 1987 · S/N E-2364 N3050LMadison Mitchell · Guthrie, OKBuilt 1965 · S/N 310J0050 N3050TLand T Chat · Tulsa, OKBuilt 1964 · S/N 320C0050 N3050WNordic Sun LLC · Garner, NCS/N 28-7921006 N3050YSmith Adam M · Holloman Afb, NMBuilt 1962 · S/N 18254050 N30514S&S Aircraft Inc · Bennington, VTBuilt 1974 · S/N 17264141 N30516J A Sutherland Inc · Ukiah, CABuilt 1973 · S/N 21059927 N3051AHigby James E Jr · Frederick, COBuilt 1969 · S/N D-9058 N3051CMedic Choppers LLC · Springdale, ARBuilt 1958 · S/N D-5707 N3051EBellingham Aviation Services LLC · Bellingham, WABuilt 1978 · S/N 17271420 N3051NOdendaal Willem G · Blacksburg, VABuilt 1979 · S/N 28-7990286 N3051TPacific Arts Collection LLC · Oakland, CAS/N 320C0051 N3051UPierson William Grant · Kerrville, TXBuilt 1979 · S/N 32-7940063 N3051WWong Direction LLC · Lantana, TXBuilt 1981 · S/N 28-8116276 N3051XWagner Richard L · Conroe, TXBuilt 1979 · S/N 34-7970190 N30521Sale Reported · New Bern, NCSale reported, pending cancellationBuilt 1978 · S/N 44-7995076 N30522Colvin Buster · Big Cabin, OKBuilt 1974 · S/N 17264142 N3052ACallis Edward Neill · Turlock, CABuilt 1978 · S/N 28-7990116 N3052DAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 1978 · S/N 44-7995144 N3052ERivers Edge Enterprises LLC · Nebraska City, NEBuilt 1978 · S/N 28-7990185 N3052FHofer Belik Colleen J · Sawyer, NDBuilt 1966 · S/N 18257152 N3052JParker Joe B · Uvalde, TXBuilt 1986 · S/N E-2346 N3052QBinning Marlin R · Grand River, IAFirst renewal noticeBuilt 1979 · S/N 28R-7931073 N3052SSanchez Donoso David · Miami, FLBuilt 1979 · S/N 28-7990314 N3052U6m Aviation LLC · Pleasant Hill, MOBuilt 1963 · S/N 17250652 N3052XJc Flight Inc · Wilmington, DES/N CE-1120 N3052YPingston Anthony · Plymouth, MIBuilt 1962 · S/N 18254052 N30530Banegas Jose C Zankiz · Fort Myers, FLBuilt 1973 · S/N 21059929 N3053ANorris T Mark · Tuscaloosa, ALBuilt 1978 · S/N 28-7911007 N3053ECharles City Aeronautics Inc · Charles City, IABuilt 1978 · S/N 28-7990186 N3053FBirkhold Craig Alan · Napoleon, OHBuilt 1966 · S/N 18257153 N3053HGator Hounds LLC · Winter Park, FLBuilt 1978 · S/N 32R-7985047 N3053NAnywhere Atp LLC · Mount Juliet, TNBuilt 1979 · S/N 28-7990288 N3053UJ & T Aviation LLC · Nashua, NHBuilt 1963 · S/N 17250653 N3053WVictor Echo LLC · Knoxville, TNBuilt 1994 · S/N CE-1783 N3053YMudd Joseph A · Oakland, CABuilt 1962 · S/N 18254053 N30549Lad Custom Publishing Inc · Buford, GABuilt 1973 · S/N 21059932 N3054ANocek Aviation LLC · Skaneateles, NYBuilt 1998 · S/N E3201 N3054EPrinceton Flying Club Inc · Wilmington, DEBuilt 1978 · S/N 17271421 N3054FAirlaska LLC · Gustavus, AKS/N 18257154 N3054HEconomy Supply Inc · Oilton, OKBuilt 1978 · S/N 32R-7987069 N3054KFerguson David G · Woodbridge, VABuilt 1979 · S/N 34-7970102 N3054LNationwide Aviation LLC · Hudson Oaks, TXBuilt 1979 · S/N 28-7916250 N3054MRegistration Pending · Reseda, CARegistration pendingS/N 28-7890292 N3054RJamms Aviation LLC · Bedford, NHBuilt 1994 · S/N E-2879

Back to AD 98-21-21 R1