Skip to content

Registered aircraft · 20,481

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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.

N5829FMoa Klinton J · Bellingham, WABuilt 1966 · S/N 21058829 N582TCBreak For It Aviation LLC · Draper, UTBuilt 2005 · S/N 18281550 N58302Gillett John W · Hillsboro, ORBuilt 1972 · S/N 18501966 N5830BHaberich Alexander J · Avon, COBuilt 1956 · S/N 33830 N5830FSuchy Karel · Kenosha, WIBuilt 1966 · S/N 21058830 N5832BAircraft Structural Repair Inc · Hamilton, MTS/N 33832 N5833FVermillion Fc-1 LLC · Crystal City, TXBuilt 1966 · S/N 21058833 N5835BJepson Duwayne D · Frazee, MNBuilt 1956 · S/N 33835 N5839BReffett John S · Eagle River, AKBuilt 1956 · S/N 33839 N5841BFultz Wilbur R · Fort Benton, MTBuilt 1956 · S/N 33841 N5842BPietrs Michael · Shoreview, MNBuilt 1956 · S/N 33842 N5842FHci Properties LLC · Frankston, TXBuilt 1967 · S/N 21058842 N5842TArapaho Air LLC · Walnut Grove, CABuilt 1964 · S/N 185-0742 N5843FU3 Aviation LLC · Little Rock, ARS/N 21058843 N58441Tall Timber Flying Service LLC · Kalispell, MTBuilt 1974 · S/N U20602604 N58442Van Vleet Dennis · Kingman, AZBuilt 1973 · S/N 18262066 N58443Szeliga Mark H · Bethel, MEBuilt 1973 · S/N 18262067 N58454Thiele John E · Harrison, IDBuilt 1973 · S/N 18262074 N58457Registered aircraftBuilt 1973 · S/N 18262075 N58458Prairie Wings Aviation LLC · Victoria, TXBuilt 1973 · S/N 18262076 N58465Ram Air LLC · Portland, MEBuilt 1973 · S/N 18262079 N58466Aerial Transport LLC · Dover, DEBuilt 1974 · S/N U20602609 N58467Schaefer Leonard · Oak Dale, PABuilt 1973 · S/N 18262081 N58469Caj Holdings LLC · College Station, TXBuilt 1973 · S/N 18262083 N58470Kraiger Rockne C Trustee · Galesburg, MIBuilt 1973 · S/N 18262084 N58472West Central Construction LLC · Indian Valley, IDBuilt 1973 · S/N 18262086 N5847BHart Johndale · Pagosa Springs, COS/N 33847 N58483Thaxton James T · Mcminnville, TNBuilt 1973 · S/N 18262093 N58484Centurion Enterprises Inc · Lake Elmo, MNBuilt 1973 · S/N 18262094 N58488Gillies Ken G · Stockton, CABuilt 1973 · S/N 18262097 N5848BOdenbrett Jeffrey E · Brighton, COFirst renewal noticeBuilt 1956 · S/N 33848 N58496Gubran Robert S · Monterey Park, CABuilt 1973 · S/N 18262103 N58498Wooding William W · Anacortes, WABuilt 1973 · S/N 18262104 N584AFAda Forestry Division · Malvern, ARBuilt 1972 · S/N 18261153 N584LQAir Shares LLC · Casper, WYBuilt 2005 · S/N 18281600 N58502H E Fly Float LLC · Virginia Beach, VABuilt 1974 · S/N U20602618 N58504P S C Flyers · Cardiff By The Sea, CABuilt 1973 · S/N 18262107 N58505Pike Medical Inc · Chillicothe, OHBuilt 1973 · S/N 18262108 N58506Krume Eric R · Castle Rock, WABuilt 1973 · S/N 18262109 N5850F5850f LLC · Monroe Township, NJBuilt 1967 · S/N 21058850 N58515Cowan Michael A · Buckeye, AZBuilt 1973 · S/N 18262115 N58517Walthers Michael L · Portland, ORBuilt 1973 · S/N 18262116 N58518N58518 Flying Club LLC · Vancouver, WABuilt 1973 · S/N 18262117 N58522Ryan Donald E · Fort Payne, ALBuilt 1973 · S/N 18262119 N5852BShaw David V · Colville, WABuilt 1956 · S/N 33852 N5852FAlvidrez Investments Group Inc · Lakewood, CABuilt 1967 · S/N 21058852 N58546Satara Inc · Frisco, TXBuilt 1973 · S/N 18262130 N58548Khbp LLC · Donnelly, IDBuilt 1973 · S/N 18262132 N58549Sale Reported · Rio Rico, AZSale reported, canceledBuilt 1973 · S/N 18262133 N5854BCruson James W · Spring Creek, NVBuilt 1956 · S/N 33854

Back to AD 84-10-01 R1