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.

N16311Toxen Robert M · Fort Lauderdale, FLBuilt 1973 · S/N 28R-7335124 N16313Sanders Christopher Scott · Knoxville, TNBuilt 1973 · S/N 28-7310085 N16317Wolf Aviation Network Inc · Westfield, MABuilt 1973 · S/N 28-7325223 N16318Enbom Brian Trustee · Discovery Bay, CABuilt 1973 · S/N 28-7325241 N16319Bethers Michael R · New Market, MDBuilt 1973 · S/N 28-7305224 N1631ESkywarrior Flight Training LLC · Pensacola, FLBuilt 1978 · S/N 17271073 N1631JReds Aircraft LLC · Edinburg, TXBuilt 1969 · S/N 28-25416 N16320Basurto Kathryn A · Sacramento, CABuilt 1973 · S/N 28-7305225 N16321Chamberlain Frederick L · Tavernier, FLBuilt 1973 · S/N 28R-7335126 N16322Liggett Esaias Martin · Union, KYBuilt 1973 · S/N 28-7310086 N16326Jakuszeski Anthony G · Washington, MIBuilt 1973 · S/N 28-7305227 N16329Greensite Phillip M · Walton, KYBuilt 1973 · S/N 28R-7335129 N1632CWarren Mark W · Arlington, WABuilt 1953 · S/N 30332 N1632EXin Han Aviation LLC · Atwater, CABuilt 1978 · S/N 17271074 N1632FBastion Allen L · Conton, PAS/N 17255027 N1632HM & B Aero LLC · York, PABuilt 1977 · S/N 28-7790319 N1632JDavid A Bowden · Duncan, OKBuilt 1968 · S/N 28-24019 N1632MD&J Training Planes LLC · Logan, UTBuilt 1975 · S/N 18264398 N1632WCdg Aviation LLC · Cresson, TXBuilt 1972 · S/N D-9363 N16332Brown Chritopher M · Lake Helen, FLBuilt 1973 · S/N 32-7300023 N1633MHill David A · North Ridgeville, OHBuilt 1975 · S/N 18264399 N1633XRhodes Donald P · Fort Worth, TXBuilt 1975 · S/N 21060669 N16340Schwartz Gregg M · Ambler, PABuilt 1973 · S/N 28-7325245 N16341Schmitz Frederick · Atlanta, GAS/N 28-7325246 N16348Mcelyea Shawn T · Aledo, TXBuilt 1973 · S/N 28-7325249 N1634DBlackhawk Aviation LLC · Medicine Park, OKBuilt 1952 · S/N 20276 N1634FWings & A Prayer Gso LLC · Weaverville, NCBuilt 1966 · S/N 17255029 N1634JLemaire Norman J Jr · Taunton, MABuilt 1968 · S/N 28-24021 N1634WTaglieri Ronald F · Pass Christian, MSBuilt 1972 · S/N D-9378 N1634XBadwater Ranch Inc · Lysite, WYBuilt 1975 · S/N 21060670 N1634YWager Douglas K · Mobridge, SDBuilt 1962 · S/N 17249334 N16350Dunn Mitchell R · Hayden, ALS/N 28-7305229 N16351Degraaff Norman L · Friday Harbor, WABuilt 1973 · S/N 28-7305231 N16357Ktup Aviation LLC · Belden, MSBuilt 1973 · S/N 28-7325253 N16359Skinner Colin L · Hartland, VTBuilt 1973 · S/N 28-7305233 N1635JDalsco Inc · Dover, DES/N 28-24820 N1635WTullos Hugh S III · Oklahoma City, OKBuilt 1972 · S/N E-350 N16361Fly 361 LLC · Doswell, VABuilt 1973 · S/N 28R-7335134 N16362Flightline Air Service LLC · Pineville, LABuilt 1973 · S/N 28R-7335135 N16363Bloemker Edward L · Fremont, NEBuilt 1973 · S/N 28-7310090 N16365Harding Keith A · Newport News, VABuilt 1973 · S/N 28-7325255 N16367Swartzbacker Paul · New Lenox, ILBuilt 1973 · S/N 28-7305237 N16368Tougas William E · Timberlake, NCBuilt 1973 · S/N 28R-7335136 N1636DDeruiter Don DBA · Lake City, MIBuilt 1952 · S/N 20278 N1636FRolfe Harold B Trustee · Holtville, CABuilt 1966 · S/N 17255031 N1636HBlue Sky Pilots Inc · Salem, ORS/N 28-7725148 N1636PCorsnitz Bryan Scott · Huntington Beach, CABuilt 1978 · S/N 32R-7887228 N1636XMonke Farm & Cattle Co · Nickerson, NEBuilt 1975 · S/N 21060672 N1636YHokanson Anthony Drake · La Crosse, WIBuilt 1962 · S/N 17249336 N16371Melendy Corey Wayne · Enid, OKBuilt 1973 · S/N 28-7310091

Back to AD 98-21-21 R1