Skip to content

Registered aircraft · 26,232

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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.

N7694THeaps John J · Dunlap, IABuilt 1960 · S/N 47294 N7694UDanfelt Eric A · Bend, ORBuilt 1976 · S/N 15077820 N76950Beare Michael · Camano Island, WABuilt 1946 · S/N 11396 N76951Wallace Carey · Knoxville, TNBuilt 1946 · S/N 11397 N76952Kling Ronald L · Kimberling City, MOBuilt 1946 · S/N 11398 N76954Nemmers Joseph P · Trent, SDBuilt 1946 · S/N 11400 N76955Pell Daniel · Naperville, ILBuilt 1946 · S/N 11401 N7695MOboyle Thomas R · Manhattan, KSBuilt 1959 · S/N 55995 N76962Burwell Daniel G · Spanaway, WABuilt 1946 · S/N 11408 N76967Johnson Gary D · Trinidad, CAS/N 11413 N7696EReedy James · Fairfield, IDS/N 7FC-291 N7696MForchtner Thomas J · Oklahoma City, OKBuilt 1959 · S/N 55996 N76974Ansorge Inc · Elk Grove, CAS/N 11420 N76975Day Samuel · Topeka, KSBuilt 1946 · S/N 11421 N76977Lapointe Teagan · Gig Harbor, WABuilt 1946 · S/N 11423 N76978Pelz Michael J · Etowah, NCBuilt 1946 · S/N 11424 N7697TElliott Jason Rex · Brawley, CABuilt 1960 · S/N 47297 N7697UFox Norman A · Maryville, TNBuilt 1976 · S/N 15077823 N7697XDecker Sidney R · San Marcos, TXBuilt 1961 · S/N 17248197 N76980Acme Aircraft Leasing Mt LLC · Kalispell, MTBuilt 1946 · S/N 11426 N76983Bridges Jesiah M · Muncie, INBuilt 1946 · S/N 11429 N76985Mandella Joseph · Harrison, ARBuilt 1946 · S/N 11431 N76989Thompson Randy L · Anderson, CABuilt 1946 · S/N 11435 N7698TGerman Jamison K · Greenville, MIBuilt 1960 · S/N 47298 N7698ULudwig Edwin E · Stephens City, VAS/N 15077824 N76994Speer Anthony F · Caldwell, IDS/N 11440 N76995Melia Daniel J · Burlington, COBuilt 1946 · S/N 11441 N7699TThomas Ag Aerial Inc · Thomas, OKBuilt 1960 · S/N 47299 N769KRWalsh William T · Tumwater, WABuilt 2016 · S/N 001 N769MFielding Floyd M · Owasso, OKS/N 26962 N769RPAntique Airplane Association Of Colorado · Longmont, COS/N CJ3 N76BWEmley Richard A · Huntington, INBuilt 1976 · S/N 1976-1 N76CBushby Harvey M · Minooka, ILBuilt 1972 · S/N 727 N76ELRed Willow Rescue Inc · Cooperstown, NDBuilt 1957 · S/N 18-6189 N76HVScholz Francis M · Atchison, KSBuilt 1976 · S/N 15078633 N76JBKilroy Kevin J · East Northport, NYBuilt 1946 · S/N 2010 N76JDAnderson Steven · Jackpot, NVBuilt 2009 · S/N CC11-00094 N76MAAnderson Daniel J · Campbellsport, WIFirst renewal noticeBuilt 1959 · S/N 55892 N76MWRoupoli Lou · San Pedro, CABuilt 1946 · S/N 8633 N76RBeech O Sphere LLC · Casper, WYBuilt 1974 · S/N 1 N76STStefenelli Aviation N-Tr Inc Trustee · AtterseeBuilt 1975 · S/N 15077396 N76YSEstrada Ernesto Alejandro · Yuma, AZBuilt 1965 · S/N 15062483 N77007Tanner Paul L · Savoy, TXBuilt 1946 · S/N 11453 N77008Hooker Robert E · Hamer, SCBuilt 1946 · S/N 11454 N77009Tardif Peter J · Pittsburg, NHFirst renewal noticeBuilt 1946 · S/N 11455 N7700EBachman Aviation Inc · Winter Haven, FLBuilt 1959 · S/N 17500 N7700FClairy Scott M · Justin, TXBuilt 1966 · S/N 15063800 N7700UJarvis Tree Service Inc · Heber Springs, ARBuilt 1964 · S/N 17251700 N7700XRule Paul Crane Trustee · Wapato, WABuilt 1961 · S/N 17248200 N77011Altherr James H · Fairbanks, AKBuilt 1946 · S/N 11457

Back to AD 94-05-05 R1