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.

N2381NHoyt Vance E Jr · Marina, CAS/N 38-79A0817 N2382VAnywhere Atp LLC · Mount Juliet, TNBuilt 1982 · S/N 38-82A0061 N23831Zekology LLC · Grayslake, ILS/N 38-79A1057 N2383FLaminar Aerospace LLC · Waukegan, ILBuilt 1978 · S/N 38-79A0411 N2384YArea-I Flying Club LLC · Atlanta, GAS/N 17700184 N2385CSt Charles Flying Service Inc · Portage Des Sioux, MOBuilt 1978 · S/N R18200172 N2385KHaynes Vincent L · Maumelle, ARBuilt 1979 · S/N 38-79A0610 N2386CSuiter Thomas D · Earl Park, INBuilt 1978 · S/N R18200173 N2386ENiblack Ward Scott · Tecumseh, MIBuilt 1978 · S/N 17271261 N2386NHoelzle Paul R · Fremont, OHS/N 38-79A0820 N2387KClipper Properties LLC · Saratoga, WYBuilt 1979 · S/N 38-79A0833 N2388BN2388b LLC · Salem, ORBuilt 1978 · S/N 38-79A0031 N2388TSlatner John W · Sims, NCBuilt 1978 · S/N 38-78A0787 N2388YMay James E · Nashville, GABuilt 1967 · S/N 17700188 N2389DRowland James E Jr · Pennsville, NJFirst renewal noticeBuilt 1978 · S/N 38-79A0293 N2389FDavenport Jimmy J · Hayesville, NCBuilt 1978 · S/N 38-79A0413 N2389SPhillips Aviation Enterprises Inc · Petoskey, MIBuilt 1979 · S/N R18201335 N2389TForeman O Dean · Springfield, TNBuilt 1978 · S/N 38-78A0789 N238DMCopeland Gary L · Williamsburg, MIBuilt 1972 · S/N 19-72 N238TWDunlap Allan D · Spokane, WABuilt 1981 · S/N 17275287 N23913Loop Timothy E · Orangevale, CABuilt 1979 · S/N 38-79A1064 N2391YOleksyn Anthony · Fairport, NYBuilt 1967 · S/N 17700191 N2392GPiper Aircraft Inc · Vero Beach, FLS/N 38-79A0513 N2393BReiley Hunter W · Harlingen, TXS/N 38-79A0035 N23945Sturgill Jerry R · Millers Creek, NCBuilt 1979 · S/N 38-79A1071 N2394SSale Reported · Wild Rose, WISale reportedBuilt 1979 · S/N R18201336 N2395BReed Kenneth P Jr · Roaring Spring, PABuilt 1978 · S/N 38-79A0037 N2395YRice Dwight D · Loma Linda, CABuilt 1967 · S/N 17700195 N2396SLebeouf Bros Towing LLC · Houma, LABuilt 1979 · S/N R18201337 N2396YAulbur Carl A · Martinsburg, MOBuilt 1967 · S/N 17700196 N2397AKinkade Leslie D · Charlestown, INS/N 38-78A0668 N2398NWolf Aerospace Corp · Ontario, CAS/N 38-79A0824 N2399YCarlson Carl E · Geneva, NYBuilt 1967 · S/N 17700199 N239LLLloyd Land Plane V LLC · Brighton, COBuilt 2021 · S/N 618-2021 N239SFLuke Skywalker 23 LLC · Los Altos, CABuilt 2000 · S/N 436-2000 N239SWPyles William J · Pismo Beach, CABuilt 1979 · S/N 24-0924 N239TXCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276463 N23ATCalifornia In Nice Inc · San Jose, CABuilt 1978 · S/N 17270997 N23BDCox Mike Trustee · Casper, WYBuilt 2009 · S/N 517-2009 N23DBSky High Farmers LLC · Lakeville, MNBuilt 1975 · S/N 17264474 N23GDPhoenix Composite Solutions LLC · Oscoda, MIBuilt 1978 · S/N 17270903 N23GVCongressional Flying Club · Gaithersburg, MDBuilt 1974 · S/N 17264594 N23JMMaynard Jared M · Kendall, NYBuilt 1998 · S/N 1244-98 N23LNJw Air LLC · Suffolk, VABuilt 1975 · S/N 550-75 N23MDBell William P · Gainesville, GABuilt 1981 · S/N 24-1247 N23MZGulfstream Media LLC · Daytona Beach, FLBuilt 1972 · S/N 17260459 N23PZInternational Air Services Inc Trustee · Carson City, NVS/N 975-2004 N2401BArasmith Richard J · Sandy Valley, NVBuilt 1978 · S/N 38-79A0045 N2401FPiper Aircraft Inc · Vero Beach, FLBuilt 1978 · S/N 38-79A0417 N2402KHughes Travis · Willow Park, TXS/N 38-79A0618

Back to AD 80-25-07 R1