Skip to content

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.

N2042QKachemak Bay Flying Service Inc · Temple, TXBuilt 1975 · S/N 17265453 N2042RJanssen David W · Ault, COBuilt 1964 · S/N 18255242 N2042SGausman Grace K · Lompoc, CABuilt 1975 · S/N 21061009 N20431Organization Of Black Aerospace Professionals · Westchester, ILBuilt 1972 · S/N 17261283 N20437Wingsleasing LLC · Wichita, KSBuilt 1972 · S/N 17261287 N20439Wilken Virginia · Sequim, WABuilt 1972 · S/N 17261289 N2043ACampion Richard · Tampa, FLBuilt 1978 · S/N TH-983 N2043GBreaking Wind LLC · Alabaster, ALBuilt 1978 · S/N TC-2189 N2043MPaxton Flyers · Loda, ILBuilt 1977 · S/N 28-7816241 N2043RBoltjes Thomas S · Platte, SDBuilt 1969 · S/N 28-5441 N2043SAppel Daniel E · Redfield, SDBuilt 1975 · S/N 21061010 N2043XWright Air Service Inc · Fairbanks, AKBuilt 1978 · S/N E-1387 N2043YGrierson Robert A · Queen Creek, AZBuilt 1962 · S/N 17249543 N20443Walker Martha D · Auburndale, FLBuilt 1972 · S/N 17261291 N20444Cesafsky Allen A · Bend, ORBuilt 1978 · S/N CE-824 N20445Norman Chuck DBA · Zanesville, OHBuilt 1972 · S/N 17261293 N20448Delta Echo Whiskey LLC · Apopka, FLBuilt 1982 · S/N R18201923 N2044ABrowder Daniel Klemp · Shady Valley, TNBuilt 1979 · S/N TJ-190 N2044GSpear Michael J · Sandpoint, IDBuilt 1958 · S/N 51344 N2044KSchutze Curt · Knoxville, TNBuilt 1978 · S/N E-1389 N2044MDowling Michael L · Adrian, MIBuilt 1977 · S/N 28-7816242 N2044PSnoe Gary A · Somerville, TXS/N TC-2178 N2044RMiller Steven Chris · Royse City, TXBuilt 1964 · S/N 18255244 N2044VPerformance Construction LLC · Paris, TXBuilt 1978 · S/N E-1390 N2044WMccraw Richard L Trustee · Hinesburg, VTBuilt 1978 · S/N E-1391 N2044XNc Flyers LLC · Raleigh, NCBuilt 1965 · S/N 18256144 N20451Registration Pending · Swainsboro, GARegistration pendingBuilt 1972 · S/N 17261297 N20452Bay Flying Services LLC · Pinconning, MIBuilt 1972 · S/N 17261298 N20454Rl Aviation LLC · Miami, FLBuilt 1972 · S/N 17261300 N20455Kachemak Bay Flying Service Inc · Temple, TXBuilt 1972 · S/N 17261301 N20457Gulf Atlantic Airways Inc · Gainesville, FLBuilt 1972 · S/N 17261303 N2045CBarreto Antonio Trustee · Norco, CABuilt 1978 · S/N E-1392 N2045EDouble P Investments LLC · Kerrville, TXBuilt 1978 · S/N E-1393 N2045XOsborne David A · Helotes, TXS/N 18256145 N2045YAir Dakota Flite Inc · Hettinger, NDBuilt 1962 · S/N 17249545 N20463Merritt Daniel D · Graham, WABuilt 1981 · S/N 18053187 N204648231 Tango Enterprises LLC · Guthrie, OKBuilt 1972 · S/N 17261308 N20465C Flyers Inc · Dyersville, IABuilt 1972 · S/N 17261309 N2046RBiser Group LLC · Huntington, WVBuilt 1969 · S/N 28-5443 N2046SYankee Clipper LLC · Dayton, OHFirst renewal noticeS/N 21061013 N2046WKj Cessna LLC · Waxahachie, TXBuilt 1978 · S/N CE-825 N2046YBrainerd William F III · Sapello, NMBuilt 1978 · S/N E-1395 N2046ZFreedom Flying Club LLC · Fort Collins, COBuilt 1978 · S/N E-1396 N20470Dameron Cleveland Forrester · Wicomico Church, VABuilt 1972 · S/N 17261313 N20471Cp Aircraft Leasing LLC · Danville, CABuilt 1972 · S/N 17261314 N20472N20472 LLC · Opa Locka, FLBuilt 1972 · S/N 17261315 N20474Voinovich John · Ogden, UTBuilt 1972 · S/N 17261317 N20478V35b Bonanza LLC · Temecula, CAS/N D-10194 N2047BField Inspection LLC · Brawley, CABuilt 1978 · S/N E-1394 N2047ESeaside Cycles Inc · Johns Island, SCBuilt 1978 · S/N 17271131

Back to AD 98-21-21 R1