Skip to content

Registered aircraft · 40,472

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.

N35608Scenic Mountain Air Inc · Moose Pass, AKS/N 17256860 N35609Unruly Passengers LLC · Piedmont, SCBuilt 1968 · S/N 17256861 N3560ECrawford James M · Sparta, MIBuilt 1979 · S/N 28-8016186 N3560PRichardson Billy J · Friendswood, TXBuilt 1955 · S/N 22-3316 N3560VAmdor John E · Harlan, IABuilt 1979 · S/N 28-8090182 N3560ZBolding Ronald B · Aguila, AZBuilt 1960 · S/N 22-7474 N35615Stoddart Eugene T · Lodi, CABuilt 1968 · S/N 17256863 N35617Britt David J · Somerset, KYS/N 17256865 N35618San Juan Flyers LLC · Friday Harbor, WAS/N 17256866 N35623Rtd Aviation LLC · Hillsborough, NJBuilt 1968 · S/N 17256869 N35626Eubanks Mitchell N Jr · San Antonio, TXBuilt 1968 · S/N 17256871 N35627Wright William F · Hobbs, NMBuilt 1968 · S/N 17256872 N35628Plane Junkies LLC · Dover, DEBuilt 1968 · S/N 17256873 N35629N35629 LLC · Brunswick, GAFirst renewal noticeBuilt 1968 · S/N 17256874 N3562DXin Han Aviation LLC · Atwater, CABuilt 1979 · S/N 44-8095014 N3562GTroy Oakland Pilots Flying Club Inc · Troy, MIBuilt 1979 · S/N 28-8090186 N35632Briden Gordy D · Stacy, MNBuilt 1968 · S/N 17256876 N35638Newberry Ernest B Jr · Crawfordville, FLBuilt 1968 · S/N 17256879 N3563EPang Clifford S · Coppell, TXBuilt 1978 · S/N 17271589 N3563QKd3262 LLC · Downers Grove, ILBuilt 1973 · S/N 17261673 N35644Pratt Sanders · Renton, WABuilt 1968 · S/N 17256882 N3564EGenerals International Inc · Red Oak, TXBuilt 1978 · S/N 17271590 N35651Schubnell Ryan A · Avondale Estates, GAS/N 17256884 N35656Hew Llp · Beresford, SDBuilt 1968 · S/N 17256888 N3565KDb Dickinson Farms Inc · Brighton, IAFirst renewal noticeBuilt 1967 · S/N 28-23629 N3565PPavia Joshua A · Alamogordo, NMBuilt 1955 · S/N 18-4557 N3565ZLewis William D · Shelbyville, TNBuilt 1960 · S/N 22-7480 N35662Warbington Michael L · Enid, OKS/N 17256890 N35665Imes Rusty J · Greenacres, WAS/N 17256893 N35667Gamby John E · Chadron, NEBuilt 1968 · S/N 17256895 N35668Schwartz Brenda A · San Angelo, TXBuilt 1968 · S/N 17256896 N35669Selkirk Seaplanes LLC · Hayden, IDBuilt 1968 · S/N 17256897 N3566ECronk Jack L · Fallbrook, CABuilt 1978 · S/N 17271591 N35671Clemons Preston J · Andover, KSBuilt 1979 · S/N 28-8016204 N35672Leaseair LLC · Wilmington, DEBuilt 1968 · S/N 17256898 N35673Knutson Ronald J · Tacoma, WABuilt 1968 · S/N 17256899 N35675Scholand Gregory J · West Ossipee, NHBuilt 1968 · S/N 17256900 N35678Trone Gary L · Taylorville, ILBuilt 1968 · S/N 17256903 N3567PWoolington James D · Dillingham, AKBuilt 1955 · S/N 18-4559 N3567QIosco Flying Club · East Tawas, MIBuilt 1973 · S/N 17261674 N35680Pilot Studio LLC · Sabana Seca, PRS/N 17256905 N35683Dmac Aircraft LLC · Savannah, GABuilt 1968 · S/N 17256906 N35689Faulkison Brian S · Watkins, COBuilt 1979 · S/N 28-8090193 N3568EColonial Air Inc · New Bedford, MABuilt 1978 · S/N 17271592 N3568ZUelner Nathan · Cedar Falls, IABuilt 1960 · S/N 22-7484 N35690Mcauliffe Pat · Collegeville, PABuilt 1968 · S/N 17256911 N35696Beisel Johnathan · Owasso, OKS/N 17256914 N3569DFtaviation LLC · Chantilly, VABuilt 1979 · S/N 28-8090168 N3569ZKleewein Daniel A · Pewaukee, WIS/N 22-7485 N356DMMader Aaron J · Sheridan, WYBuilt 2005 · S/N 21231

Back to AD 80-04-03 R2