Skip to content

Registered aircraft · 25,370

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-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N35564Port Townsend Aero Museum · Port Townsend, WABuilt 1968 · S/N 17256838 N35565Cochran Brent D · Sandy Valley, NVBuilt 1968 · S/N 17256839 N35567Searfus Kirsten · Durango, COBuilt 1968 · S/N 17256840 N35568Advance Development Inc · Muskogee, OKBuilt 1976 · S/N 177RG1053 N35569Long Daniel W · Carrollton, GABuilt 1968 · S/N 17256841 N35575Sky Flight Robotics Inc · Freeland, MIS/N 17256845 N35577Griffin Terry R · Rock Hill, SCBuilt 1968 · S/N 17256846 N35581N35581 LLC · Longview, TXBuilt 1968 · S/N 17256848 N35586Smith John S · Easthampton, MABuilt 1968 · S/N 17256853 N3558EVisalia Flyers LLC · Visalia, CABuilt 1978 · S/N 17271586 N3559HTipps Brandon · Shelbyville, TNBuilt 1977 · S/N 20-1233 N355AAAbove All Aviation Inc · Santa Barbara, CABuilt 1980 · S/N 15284224 N355BGGrabhorn Bart · Scappoose, ORBuilt 2021 · S/N 613-2021 N355DTForster George A · Port Townsend, WABuilt 1994 · S/N 24-3340 N355GPersonal Aviation Inc · Poway, CABuilt 1979 · S/N 17272564 N355RLRegistered aircraftBuilt 1995 · S/N 24-3373 N355VAVictory Aviation Club Inc · Hamilton, OHBuilt 1976 · S/N 17267135 N355YPlussa Mark George · Clermont, FLBuilt 1980 · S/N 21064137 N35608Scenic Mountain Air Inc · Moose Pass, AKS/N 17256860 N35609Unruly Passengers LLC · Piedmont, SCBuilt 1968 · S/N 17256861 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 N35632Briden Gordy D · Stacy, MNBuilt 1968 · S/N 17256876 N35638Newberry Ernest B Jr · Crawfordville, FLBuilt 1968 · S/N 17256879 N35639Sandwich Hawk LLC · Newark, ILS/N 17256880 N3563EPang Clifford S · Coppell, TXBuilt 1978 · S/N 17271589 N3563NHill Michael T · Cedarpines Park, CABuilt 1968 · S/N 680097 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 N3564LShepherd William M · Virginia Beach, VABuilt 1978 · S/N 0803 N35651Schubnell Ryan A · Avondale Estates, GAS/N 17256884 N35653Fitzgerald Bryan L · Craig, AKBuilt 1968 · S/N 17256886 N35656Hew Llp · Beresford, SDBuilt 1968 · S/N 17256888 N3565JKendrick Ross Mitchell · Sycamore, GABuilt 1980 · S/N T18803651T 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 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

Back to AD 80-25-07 R1