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.

N46259Cobra Cavalier LLC · Mooresville, NCBuilt 1978 · S/N 15283022 N4625ZAgnew Alfred Paul · Palm Beach Gardens, FLS/N 22-8140 N46261Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15283024 N46275D Gordon Aviation Inc · La Jolla, CABuilt 1978 · S/N 15283027 N4627ZPope County Aviation LLC · Russellville, ARBuilt 1961 · S/N 22-8142 N46286Cape May Aerial Advertising LLC · Rio Grande, NJBuilt 1942 · S/N G-95 N4628ZBratager Jeffrey B · Erskine, MNBuilt 1961 · S/N 22-8144 N4629ZCollins Cody W · Palestine, TXBuilt 1961 · S/N 22-8145 N462TATomlinson Aviation Inc · Ormond Beach, FLBuilt 1979 · S/N 15283554 N46308St Cloud State Univ Aero Club Inc · St Cloud, MNBuilt 1978 · S/N 15283029 N4631BAces High Aviation LLC · Long Beach, CABuilt 1979 · S/N 15283558 N4635LIndiana State University · Terre Haute, INBuilt 1980 · S/N 15284201 N46366Stockton Raymond L · Pearl City, HIBuilt 1978 · S/N 15283039 N4636ZJenkins Thomas L III · Perry Park, KYBuilt 1961 · S/N 22-8153 N46393Sam Aviation LLC · Long Beach, CAS/N 15283042 N463ATriggs Robert · Lubbock, TXBuilt 1995 · S/N 30F N464Trn Aviation LLC · Lewes, DEFirst renewal noticeBuilt 1979 · S/N 38-79A0682 N4640BChapel Hill Flying Club DBA · Sanford, NCBuilt 1979 · S/N 15283560 N4640ZGent Richard · Lancaster, TXS/N 22-8158 N46413Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15283045 N4641PRiverside Flight Center Inc · Tulsa, OKBuilt 1980 · S/N 15284790 N4641ZZenisek Michael W · Fairfax, IABuilt 1961 · S/N 22-8160 N46473Aviation Capital Management LLC · San Jose, CABuilt 1978 · S/N 15283056 N46487Silver Express Co · Miami, FLBuilt 1978 · S/N 15283061 N4649MDaviation Inc · Willoughby, OHBuilt 1980 · S/N 15284474 N464BFMoore John W · Salome, AZBuilt 2024 · S/N 11-001 N46500Montgomery Stephen C · Charlotte, NCS/N 15283063 N4652ZCardinali Andrew J · Kirkland, ILBuilt 1961 · S/N 22-8174 N4653LTfa Aircraft Holding Corp · Daytona Beach, FLBuilt 1980 · S/N 15284208 N46541Jodkin Jason · Confluence, PAS/N 15283068 N4654BXin Han Aviation LLC · Atwater, CABuilt 1979 · S/N 15283564 N4654ZHanson Donald K · Tampa, FLBuilt 1961 · S/N 22-8177 N46553Colonial Air Inc · New Bedford, MABuilt 1978 · S/N 15283072 N4655HWest Bend Air Inc · West Bend, WIBuilt 1979 · S/N 15283963 N46574Martz G Rodney · Frederick, MDBuilt 1978 · S/N 15283076 N4657ZShort Michael J · Independence, ORBuilt 1961 · S/N 22-8180 N4658BOwens Flight Training LLC · Lafayette, LABuilt 1979 · S/N 15283567 N4661BGalovich David J · Roselle, ILBuilt 1979 · S/N 15283569 N4661QLaguna Verde Leasing Inc · Wilmington, DEBuilt 1981 · S/N 15285047 N4662ZRegistration Pending · Georgetown, TXRegistration pendingS/N 22-8189 N46644Chubb Michael R · Estell Manor, NJBuilt 1978 · S/N 15283083 N46648Signs William E · Addison, TXBuilt 1978 · S/N 15283084 N46649Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15283085 N4664ZAsh Leslie A · Lebanon, TNBuilt 1961 · S/N 22-8193 N46657Ormond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1978 · S/N 15283087 N4669AWolstenholme Ralph E · Westfield, PABuilt 1979 · S/N A1520860 N46725Cloud Dancer Aviation Inc · Deland, FLS/N 15283095 N4673ZNeuenburg James A · Clark Fork, IDFirst renewal noticeS/N 22-8206 N46748Roscioli Lamberto · Lighthouse Point, FLBuilt 1978 · S/N 15283098 N4674ZHoadley Todd F · Springfield, OHBuilt 1961 · S/N 22-8207

Back to AD 80-25-02 R2