Skip to content

Registered aircraft · 8,920

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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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.

N4385YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1969 · S/N 25-4892 N4386YSoaring Club Of Houston · Waller, TXBuilt 1969 · S/N 25-4893 N4387PAurora 17 Holdings LLC · Aurora, ORBuilt 1960 · S/N 23-1898 N438CBCalifornia Baptist University · Riverside, CABuilt 2017 · S/N 4496404 N438PABird Acquisition LLC · Phoenix, AZS/N 4496083 N4394PJohnson Christopher R · Tulsa, OKBuilt 1960 · S/N 23-1906 N4395PHesse Paul W · Oxford, NCBuilt 1960 · S/N 23-1904 N4399PSchrunk Lloyd E · Canby, MNBuilt 1960 · S/N 23-1911 N43BLockard Seth J · Lebanon, TNBuilt 1963 · S/N 30-226 N43CCWpb Pilot Service LLC · West Palm Beach, FLBuilt 1965 · S/N 27-2820 N43CJLester Trevor L · Monte Vista, COBuilt 1959 · S/N 22-6928 N43HBConefry Michael A · Belle Chasse, LABuilt 1974 · S/N 27-7405379 N43PTOso Air LLC · Missoula, MTS/N 27-7305217 N43TLT M L Aircraft Inc · Narrowsburg, NYBuilt 1971 · S/N 24-5001 N4402YGoven Benjamin T · Turtle Lake, NDBuilt 1966 · S/N 25-4008 N4404AHanson Toby J · Webster, MNBuilt 1956 · S/N 22-3731 N4405ECae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 4496339 N4405JCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 4496340 N4405KCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 4496341 N4405NCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 4496342 N4405QCae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 4496343 N4407ALange Brent W · Howard, OHBuilt 1956 · S/N 22-3735 N4408AGalloway Douglas A · Sandusky, OHBuilt 1956 · S/N 22-3736 N440MKAtp Aircraft 8 LLC · Wilmington, DEBuilt 2001 · S/N 4496068 N440PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 4496084 N4411PJackson James O · Lake Charles, LAS/N 23-1923 N4413ASaubert Steven R · Florence, ORBuilt 1956 · S/N 22-3741 N4415ACanter Russell L · Enterprise, KSBuilt 1956 · S/N 22-3743 N441HGGeorgia Aviation Authority · Eastman, GABuilt 1995 · S/N 4496003 N441MA9k Air LLC · Newark, DEBuilt 2021 · S/N 4496526 N4420YKingsley Kiman J · Miller, MOBuilt 1966 · S/N 25-4040 N4421PAmendt Joseph J Jr · Watertown, SDBuilt 1960 · S/N 23-1935 N4422AHackwell Calvin · Enoch, UTBuilt 1956 · S/N 22-3751 N4424AHulme Randi M · Kimberly, IDBuilt 1956 · S/N 22-3753 N4426AShankle Matthew B · Culpeper, VAS/N 22-3755 N4426YR & S Enterprises · Fort Wayne, INBuilt 1971 · S/N 27-4708 N4427ARhinehart Daniel · Placentia, CABuilt 1956 · S/N 22-3756 N4428PSilver Creek Glider Club · New Douglas, ILBuilt 1964 · S/N 25-2719 N4428YCherry Hill Aviation Inc · Freetown, INS/N 25-4053 N4429APrillwitz Nolan D · Appleton, WIBuilt 1956 · S/N 22-3758 N4429PRegistration Pending · Kenai, AKRegistration pendingBuilt 1960 · S/N 23-1945 N4429YBlackstone Aircraft LLC · Hartselle, ALS/N 25-4055 N442BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2019 · S/N 4496460 N442HGGeorgia Aviation Authority · Eastman, GABuilt 2001 · S/N 4496056 N442MKG&M Aircraft Inc · Wheat Ridge, COBuilt 1979 · S/N 44-7995301 N442RMRocky Mountain College · Billings, MTBuilt 2013 · S/N 4496347 N442SAG & M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 44-7995071 N4430YEvergreen Soaring Inc · Lynnwood, WABuilt 1966 · S/N 25-4056 N4431AResetarits Matthew · West Seneca, NYBuilt 1956 · S/N 22-3760 N4434APutnam Michael D · Arnold, MOBuilt 1956 · S/N 22-3763

Back to AD 85-02-05 R1