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.

N58554Mocking Bird Aviation LLC · Hanover, PAS/N 18262137 N58558Long William E · Old Town, FLBuilt 1973 · S/N 18262139 N5855BCudahy J Patrick · Bayside, CABuilt 1956 · S/N 33855 N5855FOrmiston Air LLC · Kismet, KSBuilt 1967 · S/N 21058855 N58560N58560 LLC · Zionsville, INBuilt 1973 · S/N 18262140 N5857BObrien Terence · Bonney Lake, WABuilt 1956 · S/N 33857 N58580Trgn LLC · Charleston, WVBuilt 1973 · S/N 18262153 N58582Hunsaker Joshua James · Turner, ORBuilt 1973 · S/N 18262154 N58583Triesch Charles · Houston, TXBuilt 1973 · S/N 18262155 N58586Bullock Gary L · Saint Regis, MTBuilt 1973 · S/N 18262158 N5858TAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1978 · S/N 18266683 N58591Blue Skies Aero Club · Redmond, WABuilt 1973 · S/N 18262162 N58593North Kern Aviation Inc · Wasco, CABuilt 1973 · S/N 18262164 N58597Smith John N · Martinsville, INBuilt 1973 · S/N 18262167 N5859BGrant Marsall M · Truckee, CABuilt 1956 · S/N 33859 N585AMPj Aviation LLC · Richmond Hill, GABuilt 2005 · S/N 18281585 N585BBStrickland Tracy · Driggs, IDBuilt 1973 · S/N 18262136 N585CPCivil Air Patrol · Maxwell Afb, ALBuilt 2009 · S/N 18282168 N585DBCoppeta Alfred J · Altoona, PABuilt 1973 · S/N 18262120 N58601Baker Ranches Inc · Baker, NVBuilt 1973 · S/N 18262169 N58602Leatherwood Aviation LLC - Rs N58602 · College Station, TXBuilt 1973 · S/N 18262170 N58607Pendlebury David A · Pittsboro, NCS/N 18262172 N5860FThomas Kirk F · Corpus Christi, TXBuilt 1967 · S/N 21058860 N5860JMcclain Kevin D · Westminster, CABuilt 1975 · S/N 18263567 N58620Ries Farms LLC · Hastings, MNBuilt 1973 · S/N 18262179 N58624Hoefer Bradley W · Steamboat Springs, COFirst renewal noticeBuilt 1973 · S/N 18262182 N58626Rainbow Flight Inc · Felda, FLBuilt 1973 · S/N 18262184 N58628Alste LLC · Seattle, WABuilt 1973 · S/N 18262186 N5862BJac & Phill Corp · San Ysidro, CAS/N 33862 N5862JChase Benjamin A · West Chesterfield, NHBuilt 1975 · S/N 18263569 N58631Strickler Hayden B · Euclid, MNS/N 18262188 N58633Trisha Parker Real Estate Inc · Port Angeles, WAS/N 18262190 N58634Poutre Robert P · Osceola, WIBuilt 1973 · S/N 18262191 N58635Decourley Claudette · San Diego, CABuilt 1973 · S/N 18262192 N58636Adventist World Aviation Inc · Wilson, NCBuilt 1973 · S/N 18262193 N5863BBales Charles F · Altadena, CABuilt 1956 · S/N 33863 N58641Goodell Scott W · Humboldt, IAS/N 18262198 N58645Bishop Chuck W · Gilbert, AZBuilt 1973 · S/N 18262201 N58646Capper Flying Club Inc · Lancaster, CABuilt 1973 · S/N 18262202 N58647Omara Timothy · Tampa, FLBuilt 1972 · S/N 18052277 N5864BKavanaugh James M · Gilbert, AZBuilt 1956 · S/N 33864 N5864FSkaw Jack E · New Auburn, WIBuilt 1967 · S/N 21058864 N58650Orwosky Jeff · Sulphur Springs, TXBuilt 1973 · S/N 18262205 N58652K L Aircraft LLC · Fort Myers, FLBuilt 1973 · S/N 18262206 N58653Rydman Nathan D · Moab, UTBuilt 1973 · S/N 18262207 N58658Witte Thomas L · Palestine, TXBuilt 1973 · S/N 18262212 N58659Friis Karsten · Oxford, NCBuilt 1973 · S/N 18262213 N58662Vomsaal Frederick S · Columbia, MOBuilt 1973 · S/N 18262216 N58664Hamby Eileen R · Scottsboro, ALBuilt 1973 · S/N 18262218 N58666Brewer Loyd N · Santa Maria, CABuilt 1973 · S/N 18262220

Back to AD 84-10-01 R1