Skip to content

Registered aircraft · 442

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-22-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:80-22-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:80-22-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:80-22-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:80-22-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:80-22-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.

N2457APearce Daniel P · New River, AZS/N 38-78A0699 N2457GKm Ed LLC · Ocala, FLS/N 38-79A0532 N2459AAretz David · Lakeland, FLBuilt 1978 · S/N 38-78A0700 N2459GNeely Darin A · Monee, ILBuilt 1979 · S/N 38-79A0534 N2459PZuberi Azhar · Poway, CAS/N 38-79A1031 N24606Piper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 38-79A1136 N2460KL'Hommedieu Susan · Ava, MOBuilt 1979 · S/N 38-79A0643 N24611Barrios Sergio · Lusby, MDS/N 38-79A1137 N2462CPilots Choice Aviation Equipment Leasing Co · Georgetown, TXBuilt 1978 · S/N 38-79A0197 N2462FBlack Coral Holdings LLC · Elm Grove, WIBuilt 1979 · S/N 38-79A0459 N2462KNicholson Michael E · Irvine, KYS/N 38-79A0646 N2463LBivens Kennett A · Spanaway, WABuilt 1979 · S/N 38-79A0709 N2466BFoecking James · Valley City, OHS/N 38-79A0073 N2468NSouth Texas Air Force LLC · Mission, TXBuilt 1979 · S/N 38-79A0858 N2469KPilot Ready LLC · Lime Springs, IABuilt 1979 · S/N 38-79A0654 N24704Blumer Charles · Fullerton, CAS/N 38-78A0785 N24718Piper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 38-80A0002 N2471LGuzman Gerald F · Winchester, CABuilt 1979 · S/N 38-79A0712 N2471NTwo Dot Aircraft LLC · Kalispell, MTBuilt 1979 · S/N 38-79A0859 N2472NVann Dudley C DBA · Greenville, NCBuilt 1979 · S/N 38-79A0860 N2472VColthirst Michael · Clarksville, TNBuilt 1982 · S/N 38-82A0064 N2473KGondringer Steve M · Trenton, MOS/N 38-79A0655 N2473NKline Glenn A · Iron River, MIBuilt 1979 · S/N 38-79A0861 N2474BLetourneau University · Longview, TXBuilt 1978 · S/N 38-79A0078 N2474FCoke Roger T · Clarksville, INFirst renewal noticeBuilt 1979 · S/N 38-79A0468 N2474GSchwartz Theodore Francis · Fogelsville, PABuilt 1979 · S/N 38-79A0541 N2475TDurban George E · Indianola, IABuilt 1978 · S/N 38-78A0812 N2476GSouthern Region Machine Service Inc · Castlewood, VABuilt 1979 · S/N 38-79A0542 N2476NHart Lewis W DBA · Rexburg, IDBuilt 1979 · S/N 38-79A0862 N2477KKing Mike · Corpus Christi, TXBuilt 1979 · S/N 38-79A0657 N2479KAllison Larry J · Villa Rica, GAS/N 38-79A0659 N247CVDahlman Daniel P · Washington, NCS/N 38-79A0081 N2480FDavis Essen L · Trenton, MIBuilt 1979 · S/N 38-79A0470 N24810Piper Aircraft Inc · Vero Beach, FLS/N 38-80A0008 N24817Piper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 38-80A0009 N24836Piper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 38-80A0011 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 N2485LHamilton Terry W · Bulverde, TXBuilt 1979 · S/N 38-79A0719 N2486LManley Steven T · Dallas, TXBuilt 1979 · S/N 38-79A0720 N2488CEddins Mark D · Pensacola, FLFirst renewal noticeBuilt 1978 · S/N 38-79A0202 N2488FHatter Dan D · Dumas, TXBuilt 1979 · S/N 38-79A0474 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 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

Back to AD 80-22-13