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.

N5126TBelle Fourche Flight Center LLC · Belle Fourche, SDS/N 547 N5126ZAshley Emory R · Panacea, FLBuilt 1961 · S/N 22-8767 N5128ZMoore Merritt T II · Silver Creek, NYBuilt 1961 · S/N 22-8769 N5134Ireland James L · Fort Worth, TXFirst renewal noticeBuilt 1970 · S/N 32520 N5135TRayl Benjamin E · Mason City, IAS/N 562 N5137ZHill Glenn · Belle Mead, NJBuilt 1962 · S/N 22-9431 N5139TRatliff John B · Oroville, CABuilt 1966 · S/N 437 N5139ZKnarr Perry Lee · Lock Haven, PABuilt 1961 · S/N 22-8782 N5140BSesnic Aidan · Mukilteo, WABuilt 1979 · S/N 15283772 N5142ZFlorey Carl L · Eureka, MTBuilt 1961 · S/N 22-8791 N5143XHardin John W · Fort Myers, FLS/N 669 N5143ZHonkala Michael R · Wasilla, AKS/N 22-8789 N51448Haley Robert · Livermore, CABuilt 1980 · S/N 17274313 N5144BCloud Dancer Aviation Inc · Deland, FLBuilt 1979 · S/N 15283774 N5144LEmpire Aviation · Oxford, NCBuilt 1980 · S/N 15284270 N5144TAir Trac Inc · Pasco, WABuilt 1966 · S/N 484 N5144ZUlrich Kenneth B Jr · Kingwood, TXBuilt 1961 · S/N 22-8790 N5145HFoust Michael L · Soldotna, AKBuilt 1948 · S/N 14-155 N5145XAnderson Aviation LLC · Hillsboro, NDBuilt 1969 · S/N 671 N5146HTundra Aviation Inc · Casselton, NDBuilt 1948 · S/N 14-156 N5146TMattson Randall · Richvale, CAS/N 118 N5146XChart-Airs LLC · West Terre Haute, INBuilt 1969 · S/N 672 N5146ZBeloit Aviation LLC · Beloit, WIBuilt 1961 · S/N 22-8792 N5147XBrown Russell J · Mahtomedi, MNBuilt 1969 · S/N 673 N5148TKloss Matthew Joseph · Rew, PABuilt 1967 · S/N 567 N5149HLeaders Bob O · Clear Lake, MNBuilt 1948 · S/N 14-159 N5149ZWeishaar Wallace · Livingston, TXBuilt 1961 · S/N 22-8797 N5150HGregorin Richard C · Anchorage, AKBuilt 1948 · S/N 14-160 N5150ZBarilov Yekaterina · Santa Paula, CABuilt 1961 · S/N 22-8800 N5151BTakai Hiroyasu · San Jose, CABuilt 1979 · S/N 15283778 N5151LTownsend Richard · Barrington, NHBuilt 1980 · S/N 15284273 N5151ZSanve Edwin K · Elk City, OKBuilt 1961 · S/N 22-8801 N51539Van Wagner Aerial Media LLC · Pembroke Pines, FLBuilt 1943 · S/N 10491 N5154ZSexton Gregory · Jordan, MNS/N 22-8804 N5155PKline John C · Wolcottville, INBuilt 1981 · S/N 15284885 N5155ZTowe Billy Joe Jr · Decatur, ALBuilt 1961 · S/N 22-8806 N5156HIndigenous Peoples Technology & Education Center · Dunnellon, FLBuilt 1948 · S/N 14-28 N5159EStraight Gary D · Wasilla, AKBuilt 1993 · S/N 2113 N5159TSvggp LLC · Carnation, WABuilt 1967 · S/N 189 N5159ZSiegel Scott A · Inez, KYS/N 22-8813 N515DFEralet Inc · Middletown, DEBuilt 2004 · S/N 20-0069 N5160ZWend Roger W · Charlotte, MIBuilt 1961 · S/N 22-8814 N5161TStuart M Davis Inc · Rice, WABuilt 1967 · S/N 250 N5162TAdvanced Insulation Enterprises LLC · Calhoun, LABuilt 1967 · S/N 253 N5162XMcmorries Kyle Patrick · Nacogdoches, TXBuilt 1969 · S/N 691 N5164TLeonard Bruce Danield · Spokane, WABuilt 1966 · S/N 178 N5164ZEast Texas Aircraft Engines LLC · Palestine, TXS/N 22-8819 N5165BNovember 46a Leasing Inc · St Augustine, FLBuilt 1979 · S/N 15283783 N5166ZTuttle Anthony G · Walnut Cove, NCBuilt 1961 · S/N 22-8824 N5167ZRamsdell Edmun · Modesto, CABuilt 1961 · S/N 22-8825

Back to AD 80-25-02 R2