Skip to content

Registered aircraft · 40,394

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:79-10-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2') 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:79-10-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2')
  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:79-10-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2')
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.

N84386Bell Motor Co · Cut Bank, MTBuilt 1969 · S/N 17258454 N8438HPitt Ian · Bergenfield, NJS/N 28-8290009 N8438RMorrison Doyle T · Goldthwaite, TXBuilt 1966 · S/N 28-22319 N8438YJohnson Aaron D · Colfax, WABuilt 1969 · S/N 18-8864 N84390Butts Desmon D · New Waverly, TXBuilt 1969 · S/N 17258456 N84391Vicknair Michael N · Owasso, OKBuilt 1969 · S/N 17258457 N84392Romeo Flying Club LLC · Leonard, MIBuilt 1969 · S/N 17258458 N84397Hernandez Karen K · Garden Valley, CABuilt 1969 · S/N 17258459 N8439MSteel Supply Co · Rolling Meadows, ILS/N 0371 N8439TFly Quest Aviation LLC · Pomona, CAFirst renewal noticeBuilt 1981 · S/N 28-8290012 N8439WPace Andrea · Homosassa, FLBuilt 1965 · S/N 28-2670 N8439YTracy Bill E · Leoti, KSBuilt 1970 · S/N 18-8866 N8439ZSyracuse Flying Club Inc · Fayetteville, NYBuilt 1981 · S/N 28-8190313 N843DPChoice Aviation LLC · Hamilton, MTBuilt 1969 · S/N 17258431 N844Ross George W DBA · Boise, IDS/N 709 N84400N84400 LLC · Chamblee, GABuilt 1981 · S/N 28-8216004 N84408Miyamoto Edward · Rio Vista, CABuilt 1969 · S/N 17258462 N8440BKoon Anthony Scott · Kokomo, INBuilt 1981 · S/N 28-8290013 N8440DAkn Inc · Crystal, MNBuilt 1957 · S/N 22-5695 N8440HMeyer Anthony R · Whittemore, IABuilt 1981 · S/N 28-8216001 N8440LRoot William L Trustee · Scotia, NEBuilt 1968 · S/N 17256640 N8440MAirflair Inc · Maurice, IABuilt 1981 · S/N 28-8216002 N8440WPensa Way Inc · Pensacola, FLBuilt 1965 · S/N 28-2671 N84412Sohini Vinod Rai · Lufkin, TXBuilt 1969 · S/N 17258464 N8441CCirrus Aviation Inc · Easton, PABuilt 1981 · S/N 28-8290014 N8441HEuroair Consultants LLC · Vero Beach, FLBuilt 1981 · S/N 28-8290015 N8441LG1 Aviation LLC · Ocala, FLBuilt 1968 · S/N 17256641 N8441MAmick David E · Elizabethtown, PABuilt 1981 · S/N 28-8290016 N8441WGeaney Kacy B · Alturas, CABuilt 1965 · S/N 28-2672 N84422Dhr Investments LLC · Beaumont, TXBuilt 1969 · S/N 17258467 N84429Avz Aviation Of Tennessee Inc · Knoxville, TNBuilt 1969 · S/N 17258468 N8442DFlymart Inc · Hastings, FLS/N 22-5697 N8442RBandon Aviation LLC · Bandon, ORBuilt 1966 · S/N 28-22325 N8442WInspire Aviation LLC · Magnolia, TXBuilt 1965 · S/N 28-2675 N84434Russell Aerial Photography Inc · Edgewater, FLBuilt 1969 · S/N 17258469 N8443RKor Aviation LLC · Piedmont, SDBuilt 1966 · S/N 28-22326 N8443WFew Tyus S · Roanoke Rapids, NCBuilt 1965 · S/N 28-2676 N84440Yankee Charlie LLC · Melbourne, FLBuilt 1969 · S/N 17258472 N84449Eskridge Jonathan L · Rio Rancho, NMBuilt 1969 · S/N 17258475 N8444BLutz Christine A · Acton, CABuilt 1981 · S/N 28-8290024 N8444DEtheredge Mark · Pell City, ALBuilt 1981 · S/N 28-8216012 N8444JHeartland Ag Aviation LLC · Lancaster, KSBuilt 1981 · S/N 28-8216013 N8444LRiley David R · Baltimore, MDBuilt 1968 · S/N 17256644 N8444SVertex Aviation Services LLC · Burlington, WABuilt 1982 · S/N 28-8290025 N8444WShowalter Robert B · Orlando, FLBuilt 1965 · S/N 28-2677 N84455Green Castle Aero Club · Oxford, IABuilt 1969 · S/N 17258476 N84456Warbirds East Inc · Fairhope, ALBuilt 1969 · S/N 17258477 N84459Maddox Glen E · Bushnell, FLBuilt 1969 · S/N 17258478 N8445ADowntown Goldsmith & Engraving · Deland, FLBuilt 1981 · S/N 28-8290027 N8445BStarnes Robert · Vandervoort, ARBuilt 1981 · S/N 28-8216016

Back to AD 79-10-03 R2