Skip to content

Registered aircraft · 6,349

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-02-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-25-02-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-25-02-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-25-02-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-25-02-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-25-02-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.

N9290TWings Flight Enterprises Inc · Danville, KYS/N 38-78A0328 N9296LTrites Henry E · Granville, OHBuilt 1971 · S/N AA1A-0196 N9297SNovak David J · Hortonville, WIBuilt 1996 · S/N 037 N92995Yoanna Flight School Inc · Fort Myers, FLBuilt 1981 · S/N 15285372 N9299LKing Angela · Raleigh, NCBuilt 1971 · S/N AA1A-0199 N92BASprott Robert L · Perkins, OKS/N 38-79A0013 N92TDVeillon Joseph B · Alexandria, LABuilt 1993 · S/N 001JBV N93002Lcc North LLC · Freehold, NJBuilt 1981 · S/N 15285374 N9300LWesley Robert J · Chuckey, TNBuilt 1971 · S/N AA1A-0200 N9301LColton Paul F · Orlando, FLBuilt 1970 · S/N AA1A-0001 N9302LBffe Inc · Homestead, FLS/N AA1A-0002 N9303LMathison John M · Fernley, NVS/N AA1A-0003 N9304LBraithwaite Lester T · Camino, CAS/N AA1A-0004 N9304TPiper Aircraft Inc · Vero Beach, FLBuilt 1978 · S/N 38-78A0013 N9305LSutphin Harold W · Saint Cloud, FLBuilt 1971 · S/N AA1A-0005 N9305ZRegistration Pending · Keizer, ORRegistration pendingBuilt 1956 · S/N 12-2484 N9306LRobinson Mark V · Vacaville, CABuilt 1971 · S/N AA1A-0006 N93078Black Cat Aviation LLC · Centennial, COBuilt 1981 · S/N 15285391 N93082Schweiger Nathaniel A · Richland, WABuilt 1981 · S/N 15285394 N93085Hoffsette Dianna L Trustee · Saint Catharine, MOBuilt 1981 · S/N 15285396 N9308LRegistration Pending · Horn Lake, MSRegistration pendingBuilt 1971 · S/N AA1A-0008 N93096Ngumba Andrew N · Long Beach, CABuilt 1981 · S/N 15285399 N9310LGavitte Peter F · Napa, CABuilt 1971 · S/N AA1A-0010 N93116Wichita Area Technical College · Wichita, KSBuilt 1981 · S/N 15285405 N93124Pavco Inc · Gig Harbor, WABuilt 1981 · S/N 15285409 N93127Dunn W Eric · Lake Wylie, SCBuilt 1981 · S/N 15285411 N9313LKlutz Stoner W · Bristol, TNBuilt 1971 · S/N AA1A-0201 N93142Geoffrion Curt J · Kenai, AKS/N 15285415 N9314LEastern Stearman Inc Trustee · Leesburg, VABuilt 1971 · S/N AA1A-0014 N9314TGriffith Stephen P · Merritt Island, FLBuilt 1978 · S/N 38-78A0024 N93154H & H Aviation Enterprises LLC · Fairfield, OHBuilt 1981 · S/N 15285422 N9315LWilliams Matt D · Xenia, OHBuilt 1971 · S/N AA1A-0015 N93166Kelly William W · Springfield, ORBuilt 1981 · S/N 15285428 N9318TGuerra Eduardo · Polk City, FLS/N 38-78A0028 N93196Registration Pending · Lafayette, LARegistration pendingBuilt 1981 · S/N 15285439 N931SCActiveair LLC · Erie, PABuilt 1978 · S/N 38-79A0391 N9320LColton Casey Daniel · Lutz, FLS/N AA1A-0020 N93214Sundance Air Services Inc · Alameda, CABuilt 1981 · S/N 15285444 N93239Minuteman Aviation Inc · Missoula, MTBuilt 1981 · S/N 15285447 N9324LLysogorski Edward P · Bridgeport, MIFirst renewal noticeBuilt 1972 · S/N AA1B-0038 N93251Flaherty Edward T · Scotia, NYBuilt 1981 · S/N 15285448 N9325LMartin David Gary · Huntington, ARBuilt 1971 · S/N AA1A-0025 N93263Xin Han Aviation LLC · Atwater, CABuilt 1981 · S/N 15285451 N93264Wolfe Michael S · Norco, CABuilt 1981 · S/N 15285452 N93271Pauma Holdings LLC · Colorado Springs, COBuilt 1981 · S/N 15285454 N9327TFlener Stephen J · Sterling, OHBuilt 1978 · S/N 38-78A0036 N93281Bishop Mike · Rifle, COBuilt 1981 · S/N 15285456 N9328LCastro Tony · Duluth, GABuilt 1971 · S/N AA1A-0028 N9329LHills Holding · Newark, DEBuilt 1971 · S/N AA1A-0029 N932JTMann Leslie V · Alta, IABuilt 2011 · S/N 90312

Back to AD 80-25-02 R2