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.

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 N79063Sprague Todd K · Placerville, CABuilt 1968 · S/N 17257854 N79065Kingston Thomas P · Carmel, INBuilt 1968 · S/N 17257856 N79066Doran Vincent J Jr · Wasilla, AKBuilt 1968 · S/N 17257857 N79068Padgett Leonard Dale · Hobart, OKBuilt 1968 · S/N 17257858 N7906PCastro Johnny · Porterville, CABuilt 1962 · S/N 24-3137 N79071Cottrell Mark C · Leitchfield, KYBuilt 1968 · S/N 17257860 N79072Registered aircraftBuilt 1968 · S/N 17257861 N79079Jones Farm Fresh LLC · Bartlett, TNBuilt 1968 · S/N 17257867 N7907WRegistration Pending · El Prado, NMRegistration pending, canceledBuilt 1964 · S/N 28-1937 N79086Marshall County Flying Club Inc · Lacon, ILBuilt 1968 · S/N 17257870 N79087Air Discovery La LLC · North Hollywood, CABuilt 1968 · S/N 17257871 N79089Ramaswamy Gautam · Clearwater, FLBuilt 1968 · S/N 17257872 N7908GChamberlain Bruce H · Worcester, MABuilt 1970 · S/N 17259608 N7908LUSA Aircraft Leasing LLC · Dover, DEBuilt 1966 · S/N MB-119 N7908WEmerald Coast Flying Club LLC · Fort Walton Beach, FLBuilt 1964 · S/N 28-1939 N79090Caughman John R · Katy, TXBuilt 1968 · S/N 17257873 N79092Aero Quest LLC DBA · Olive Branch, MSBuilt 1968 · S/N 17257874 N79093Bray Austin M · Pontotoc, MSBuilt 1968 · S/N 17257875 N79095Hole In The Clouds Rentals LLC · Montgomery, ALBuilt 1969 · S/N 17257877 N7909GCopass Kaneia · Fountain Run, KYBuilt 1971 · S/N 17259609 N7909WCircus Of Six LLC · Wilmington, DEBuilt 1964 · S/N 28-1942 N790ASFly4fun LLC · Buffalo Grove, ILBuilt 1978 · S/N AA5B0918 N790DWFairchild Ralph B · Wausau, WIBuilt 1994 · S/N 20369 N790GKAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 1979 · S/N 44-7995316 N790HMMota Hector · Miramar, FLS/N 1334 N790SHMichael Mollere Inc · Marion, TXBuilt 2004 · S/N 3636 N790YNostra Aeris LLC · Midway, ARBuilt 1978 · S/N M-2097 N790YAB & T Aviators Inc · Wantagh, NYBuilt 1967 · S/N 28-23668 N79102Van Wert County Regional Airport Aurthoirty · Van Wert, OHBuilt 1969 · S/N 17257882 N79104Roman Nose Flying Club Inc · Newalla, OKBuilt 1969 · S/N 17257884 N79105Linn Nicholas D · Norfolk, NEBuilt 1969 · S/N 17257885 N7910GBrusse Leslie W · Enterprise, ALBuilt 1970 · S/N 17259610 N79113Executive Flight Institute LLC · Murrieta, CABuilt 1969 · S/N 17257889 N79118Osceola Aerosport LLC · Osceola, WIBuilt 1969 · S/N 17257893 N79119Carr Randal J · Chandler, OKBuilt 1969 · S/N 17257894 N7911LAlthouse Randy A · Postville, IAS/N MB-123 N7911NRynearson Mark J · Wolcott, NYBuilt 1969 · S/N 28-5323 N7911WSandidge Richard A · Pueblo, COBuilt 1964 · S/N 28-1944 N79122Johnson John C · Squaw Valley, CABuilt 1969 · S/N 17257896 N79125Brekhus Palmer A · Tolley, NDBuilt 1969 · S/N 17257897 N79126Grounded Hangar Inc · Turlock, CABuilt 1969 · S/N 17257898 N7912LMiller Cameron · Loomis, CAS/N MB-129 N79130M&M Shipshape LLC · Kalispell, MTBuilt 1969 · S/N 17257901 N79133Rotate LLC · Eden Prairie, MNBuilt 1969 · S/N 17257903 N79136Registered aircraftBuilt 1969 · S/N 17257906 N79137Marshall Jeffery K · Pleasanton, CABuilt 1969 · S/N 17257907

Back to AD 80-04-03 R2