Skip to content

Registered aircraft · 40,471

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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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.

N78GTBennett Wayne M Jr · Puyallup, WABuilt 1978 · S/N AA5B-0853 N78HBValiair Lc Trustee · Casper, WYS/N 2066 N78HYD A Lamont Public Adjusters LLC · Springtown, TXBuilt 1999 · S/N 2048 N78JMDye William M · Atlanta, GABuilt 1976 · S/N 28-7690430 N78JNMuseum Of Flight Foundation · Seattle, WABuilt 1971 · S/N 434 N78KPYoungblood Dennis L · Crystal River, FLBuilt 1978 · S/N AA5B0758 N78KVShore Dog Aviation LLC · Dover, DEBuilt 1978 · S/N AA5A0632 N78MJTalley Patricia · Asheboro, NCBuilt 1973 · S/N 28-7325319 N78NPHeaton Justin · Lufkin, TXBuilt 2002 · S/N 444 N78NSRobertson Lester M · Hamilton, OHBuilt 1982 · S/N JAN1975-SK N78PJRothrock John W Jr · Danville, INBuilt 1978 · S/N 363-78 N78QPHilyer Bruce W Trustee · Seattle, WABuilt 1966 · S/N 18-8469 N78RFFairchild Maxwell D · Morristown, TNBuilt 1958 · S/N 22-6243 N78RTMorris Coady C · Russell, KSFirst renewal noticeBuilt 1983 · S/N 885 N78SEFlight Fundamentals Inc · Willcox, AZBuilt 2005 · S/N 1382-2005 N78SKCleveland Gary J · Plymouth, INBuilt 1997 · S/N 686R N78TKFinseth Lowell J · Fountain, MNBuilt 1978 · S/N 237 N78TMBowlin Ronald R · Camarillo, CABuilt 1977 · S/N 28-7890216 N78VLAdams Michael · Oxnard, CABuilt 1978 · S/N AA5A-0558 N78VMPileggi Anthony · Leland, NCBuilt 1992 · S/N 1482 N78WGBarros Da Costa Cristiano Manuel · Grand Forks, NDS/N 865 N79000Kemmis Sidney C · Prophetstown, ILBuilt 1968 · S/N 17257797 N79001Pau Hana Enterprises LLC Series IV · Boulder City, NVBuilt 1968 · S/N 17257798 N79002Fremont Aviation Inc · Fremont, NES/N 17257799 N79004Palmer Joe A · Meridian, IDBuilt 1968 · S/N 17257801 N79009Birkholz Raymond J · Boulder, COBuilt 1968 · S/N 17257806 N7900CSdd Aviation LLC · Thomasville, GABuilt 1975 · S/N 28-7690087 N7900GGreat Plains Enterprises LLC · Wilmington, OHBuilt 1970 · S/N 17259600 N79012Brewer Jeremiah L · Eagle River, AKBuilt 1968 · S/N 17257809 N79013Woods Michael F · Hamilton, NJBuilt 1968 · S/N 17257810 N79014Fcs Aviation LLC · Lewisport, KYBuilt 1968 · S/N 17257811 N79015Flying Weaners Inc · Jacksonville, FLBuilt 1968 · S/N 17257812 N7901CFrost Aviation Alliance LLC · North Hollywood, CABuilt 1975 · S/N 28-7690088 N7901GRaines Adam D · Ridgewood, NJBuilt 1970 · S/N 17259601 N79021Smith Timothy C Trustee · Riverton, WYS/N 17257816 N79024Jwp Flying Services LLC · Chatfield, MNBuilt 1968 · S/N 17257819 N79027Arrow North LLC · Missoula, MTBuilt 1968 · S/N 17257822 N79028Jdc Aviation LLC · Upland, CABuilt 1968 · S/N 17257823 N7902SN7902s Wings LLC · Forest City, PABuilt 1976 · S/N 332-76 N7902WHicks Mark T · Newark, CABuilt 1964 · S/N 28-1931 N79031Smith Robert L II · Spencer, WVBuilt 1968 · S/N 17257826 N79036Buiqui Aerospace Corp · Kissimmee, FLS/N 17257831 N7903GDunn Patrick J · Denver, COBuilt 1970 · S/N 17259603 N79040Higinbotham Larry L · Littleton, COBuilt 1968 · S/N 17257835 N79042N79042 LLC · Rock Hill, SCBuilt 1968 · S/N 17257837 N79048High Stakes Aviation LLC · Fresno, CABuilt 1968 · S/N 17257841 N7904GRight Rudder LLC · Rexburg, IDBuilt 1970 · S/N 17259604 N7904WRobins Steven W · Franklinton, LAS/N 28-1934 N79050Batto Jeannie L · Madison, INBuilt 1969 · S/N 17257843 N79052Rose Gary A · Brighton, TNBuilt 1968 · S/N 17257844

Back to AD 80-04-03 R2