Skip to content

Registered aircraft · 54,841

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:97-01-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13') 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:97-01-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13')
  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:97-01-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13')
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.

N105RDSunny Slope Aviation LLC · Adams, TNBuilt 1967 · S/N 17256221 N105RFRandigo LLC · Wilmington, DEBuilt 1993 · S/N 208B0353 N105SPDepartment Of Emergency Svcs & Public Protection · Hartford, CTBuilt 1984 · S/N 18268425 N105UCStem Aviation Academy · Carlsbad, CABuilt 1985 · S/N 15285998 N105VBHughes Francis A · Ltl Egg Hbr Twp, NJBuilt 1981 · S/N 18268138 N105VEPlane Fun Inc Tr Trustee · Snellville, GABuilt 1998 · S/N 208B0680 N10604Bittner Vernon J · New Richmond, WIBuilt 1973 · S/N 15074922 N1060FStrausbaugh Paul L · Clifton Forge, VABuilt 1975 · S/N 18502716 N10615Tarr Sheryl L · Spokane Valley, WABuilt 1973 · S/N 15074925 N10617Kern Aviation LLC · Shafter, CABuilt 1973 · S/N 15074927 N10618Roundy Kamlah F · Monteview, IDS/N 15074928 N1061PRemote Properties LLC · Anchorage, AKBuilt 1983 · S/N U20606773 N1061XMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 172-69458 N10621Brosh Cameron R · Loveland, COBuilt 1973 · S/N 15074930 N10628Warner Daniel D · Linden, MIBuilt 1973 · S/N 15074932 N1062FSale Reported · Independence, ORSale reportedBuilt 1975 · S/N 18502718 N10630Perez Juan Carlos · Miami Gardens, FLS/N 15074934 N10644American Flag Airlines Inc · Ft Lauderdale, FLBuilt 1973 · S/N 15074942 N10645Dearborn Edward M · Acworth, GAS/N 15074943 N10647Kosko Stanley G · Seattle, WAS/N 15074945 N10649Seaplane Adventures LLC · Cheyenne, WYS/N 15074947 N1064VHenderson Robert J · Grass Lake, MIBuilt 1977 · S/N R1722099 N10651Wampler Matthew T · Valles Mines, MOBuilt 1973 · S/N 15074948 N10653Loftin Jamie B · Shreveport, LABuilt 1973 · S/N 15074950 N10658Craigmyle William R · Cooperstown, NYBuilt 1973 · S/N 15074952 N1065VRegistered aircraftBuilt 1974 · S/N U20602435 N10661Colberg Sigurd E · Palmer, AKBuilt 1973 · S/N 15074955 N10663General Aircraft Services LLC · Pendleton, ORS/N 15074957 N10669Loeppky Neal K · Seminole, TXBuilt 1973 · S/N 15074962 N10679Samson Rene R · Lewiston, MES/N 15074968 N1067LCollins Gene William · Manassas, VABuilt 1973 · S/N 15074965 N1067MShore Enterprises Of Gainesville LLC · Gainesville, FLBuilt 1970 · S/N 21059367 N10681Chickasha Wings Inc · Chickasha, OKBuilt 1973 · S/N 15074970 N10682Thomas Edward L · West Bend, WIBuilt 1973 · S/N 15074971 N10683Burton Ryne W · Astoria, ILBuilt 1973 · S/N 15074972 N10687Boatright William L · Colonial Beach, VABuilt 1973 · S/N 15074974 N10688Wilson Oscar O Jr · Kountze, TXFirst renewal noticeBuilt 1973 · S/N 15074975 N10689Registered aircraftBuilt 1973 · S/N 15074976 N1068FDubois Marcus S · Olive Branch, MSBuilt 1979 · S/N 17272943 N1068MWolfenden Allen K · Rocklin, CABuilt 1971 · S/N 17259988 N10693Full Stop Aviation LLC · Union City, TNBuilt 1973 · S/N 15074978 N1069LWilson Michael A · Everett, WABuilt 1956 · S/N 33633 N1069VSmith Robert E · Nacogdoches, TXBuilt 1976 · S/N R1722100 N106ANTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 208B0917 N106CAHyannis Air Service Inc · Hyannis, MABuilt 1985 · S/N 402C1020 N106ESOliverson Lee Ann N · Sandy, UTS/N 17272099 N106GCJones Michael D · Warner Robins, GABuilt 1975 · S/N 17264663 N106GTGendron Paul F · Vero Beach, FLS/N 17270199 N106PKScarbrough Dean C · Deshler, OHS/N R1722098 N106PSScarrow James D · Jerome, IDBuilt 1976 · S/N 18264800

Back to AD 97-01-13