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.

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 N79054N18228 Inc · Williamsburg, VABuilt 1969 · S/N 17257846 N79055Amies John W · Zimmerman, MNBuilt 1968 · S/N 17257847 N79060K&L Aviation LLC · Prosper, TXBuilt 1968 · S/N 17257851 N79062Pierce Brenden D · Eatonville, WAS/N 17257853

Back to AD 79-10-03 R2