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.

N247APNorth Joseph · Cocoa, FLBuilt 1970 · S/N 17259066 N247BCPlane Nutz LLC · Sugar City, IDBuilt 2011 · S/N 544-2011 N247CVDahlman Daniel P · Washington, NCS/N 38-79A0081 N247LWHailey & Harmony Enterprises LLC · Las Vegas, NVS/N 172RG0314 N247MAWanda Collins Professional Pilot Services LLC · College Station, TXBuilt 2003 · S/N 932-2003 N2480FDavis Essen L · Trenton, MIBuilt 1979 · S/N 38-79A0470 N24810Piper Aircraft Inc · Vero Beach, FLS/N 38-80A0008 N24816Graves James A Trustee · Norman, OKBuilt 1977 · S/N 15280396 N24817Piper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 38-80A0009 N24831Bishop Darin R · Livermore, CABuilt 1977 · S/N 15280403 N24836Piper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 38-80A0011 N2483JWestern Pilot Service Inc · Phoenix, AZBuilt 1979 · S/N 18803467T N2483KVan De Wall Allan G · Oro Valley, AZBuilt 1979 · S/N 38-79A0660 N2484KGladden Jeffrey S · Rustburg, VABuilt 1979 · S/N 38-79A0661 N2484NChihuahua Airport Partners Lp · Plano, TXS/N 38-79A0865 N24856Mccreary Aviation LLC · Green Valley, AZBuilt 1977 · S/N 15280414 N24857Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1977 · S/N 15280415 N2485LHamilton Terry W · Bulverde, TXBuilt 1979 · S/N 38-79A0719 N2486LManley Steven T · Dallas, TXBuilt 1979 · S/N 38-79A0720 N24874Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15280427 N2487SMoody Bible Institute Of Chicago · Spokane Valley, WAS/N R18201344 N24884Bravo Victor LLC · Afton, WYFirst renewal noticeBuilt 1977 · S/N 15280431 N24886Warrior II Ltd · Des Plaines, ILBuilt 1977 · S/N 15280432 N24887Sunrise Aviation Inc · Ormond Beach, FLS/N 15280433 N2488CEddins Mark D · Pensacola, FLFirst renewal noticeBuilt 1978 · S/N 38-79A0202 N2488FHatter Dan D · Dumas, TXBuilt 1979 · S/N 38-79A0474 N24895Lokker Dirk E · Oakdale, CABuilt 1977 · S/N 15280438 N2489BKlauschie David A · Papillion, NEBuilt 1978 · S/N 38-79A0085 N2489KMartin Brennan Stern Jr · Bristol, TNBuilt 1979 · S/N 38-79A0662 N2489NDeschamps Joseph L · Barre, MABuilt 1979 · S/N 38-79A0871 N248ERUnverferth Gregory T · Fort Jennings, OHS/N 17271977 N248GTHansen Nelse · Lawrenceville, GABuilt 1981 · S/N 17274572 N248MAStick Back Aviation Inc · Le Roy, NYS/N 9362003 N248PVVasquez Pablo Javier Jr · El Dorado Hills, CABuilt 1991 · S/N 243221 N24908Hnatio Matthew J · South Deerfield, MABuilt 1977 · S/N 15280445 N2490VPiper Aircraft Inc · Vero Beach, FLBuilt 1982 · S/N 38-82A0068 N24914Piper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 38-80A0017 N2491CPearlman Lawrence A · South Boston, VABuilt 1978 · S/N 38-79A0203 N2491FCarlson Dann S · Kailua, HIBuilt 1979 · S/N 38-79A0477 N24920Springett Justin · Boulder, COS/N 15280450 N24932Silver Express Co DBA · Miami, FLBuilt 1977 · S/N 15280456 N24933Leslie Ethel M · Paonia, COBuilt 1977 · S/N 15280457 N2493845u Leasing LLC · Beaver Creek, OHBuilt 1977 · S/N 15280459 N24947Aty Aviation Inc · Watertown, SDS/N 15280464 N2494BMunger Steven D · Mifflintown, PABuilt 1978 · S/N 38-79A0092 N2495Lynch Sean L · Brighton, ILBuilt 1978 · S/N 17270282 N24950Erbisch Robert · Fruita, COBuilt 1977 · S/N 15280467 N2495APhillipine Matthew · Bonita Springs, FLBuilt 1978 · S/N 38-78A0715 N2495DGutierrez Roberto R Jr · Edinburg, TXBuilt 1978 · S/N 38-79A0333 N2497EBenham Aviation LLC · Enid, OKBuilt 1978 · S/N 17271303

Back to AD 80-25-07 R1