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.

N9170DSmith Glen R · Tracy, MNBuilt 1958 · S/N 22-6224 N9170PP&S Aviation LLC · White Rock, NMBuilt 1967 · S/N 24-4659 N9171DJensen Timothy G · Junction City, ORBuilt 1958 · S/N 22-6226 N9171PMckim Thomas F · Winston Salem, NCBuilt 1967 · S/N 24-4660 N9172PSale Reported · Henderson, NVSale reportedBuilt 1967 · S/N 24-4661 N9175SMarshall Adam A · Fremont, NEBuilt 1967 · S/N 24-4664 N9176DSmaha Daniel B · Glide, ORBuilt 1958 · S/N 22-6233 N9176PWalter Richard · Hampshire, ILBuilt 1967 · S/N 24-4665 N9177DCheyann Jordan · Coupeville, WABuilt 1958 · S/N 22-6234 N9177PCochran Charles M III · Terre Haute, INBuilt 1967 · S/N 24-4666 N9178PCarnes Harley · Ocean, NJBuilt 1967 · S/N 24-4668 N9180PHughes Travis · Willow Park, TXBuilt 1967 · S/N 24-4670 N9182PMonske Nicholas · Austin, TXS/N 24-4672 N9182TShortridge Randall R · Mesa, AZBuilt 1978 · S/N 25-7856026 N9184XContinental Title Trust LLC Trustee · Wichita, KSBuilt 1966 · S/N 30-1041 N9186DEckels Daniel R · Centerburg, OHBuilt 1958 · S/N 22-6244 N9187PJapundza Bob · Kokomo, INFirst renewal noticeS/N 24-4677 N9188PRogermoser Hanspeter · Summerville, SCBuilt 1967 · S/N 24-4678 N9188TArizona Soaring Inc · Maricopa, AZBuilt 1978 · S/N 25-7856039 N9189PThom Transport LLC · Marlette, MIBuilt 1967 · S/N 24-4680 N918YInternational Air Services Inc Trustee · Carson City, NVBuilt 1965 · S/N 30736 N9190PGreen Mark S · Ocala, FLBuilt 1967 · S/N 24-4683 N9191ECatlin Aviation Co · Okla City, OKRegistration revokedBuilt 1959 · S/N 241538 N9192DHadley Sheldon L · Hope, ARS/N 22-6251 N9193PDean Aaron · Norwich, NYBuilt 1967 · S/N 24-4686 N9194DDaniels Daryl A · Warren, OHBuilt 1958 · S/N 22-6253 N9195PHarstine Lucene May · Claypool, INBuilt 1967 · S/N 24-4688 N9196PHarris Michael · Pointblank, TXBuilt 1967 · S/N 24-4689 N9197PHardin County Aviation LLC · Kountze, TXBuilt 1967 · S/N 24-4690 N9198PBarna George · Castleton, NYBuilt 1967 · S/N 24-4692 N919ASchulze Thomas A · Bloomville, OHBuilt 1951 · S/N 22-223 N91BRRegistration Pending · South Boston, VARegistration pendingBuilt 1965 · S/N 24-4326 N91RGM&M Aviation LLC · Pelzer, SCBuilt 1958 · S/N 24-115 N91XCFitzgerald David R · Canton, OHBuilt 1971 · S/N 39-90 N9200PWings & Wheels Lease Of Central Nebraska LLC · Broken Bow, NEBuilt 1967 · S/N 24-4693 N9205DHayden Scott D · Anchorage, AKBuilt 1958 · S/N 22-6264 N9205PDt Pralle Enterprise Inc · Hampton, IAS/N 24-4700 N9206DCarpenter Richard F · Big Lake, AKBuilt 1958 · S/N 22-6265 N9207PWissler John H · Tenino, WABuilt 1967 · S/N 24-4702 N920ERSunrise Aviation · Ormond Beach, FLBuilt 1993 · S/N 4495013 N9211PBordeleau Michael V · Bridport, VTS/N 24-4706 N9212PHapka Leon J · Halma, MNFirst renewal noticeBuilt 1967 · S/N 24-4707 N9216DBlackbird Aviation LLC · Bedford, PABuilt 1958 · S/N 22-6276 N9216PWilliams Dayre · Red Cloud, NEBuilt 1967 · S/N 24-4712 N9217DBischoff Danielle I · Palmer, AKBuilt 1958 · S/N 22-6277 N9217PGruber Joachim R · Elizabethtown, KYFirst renewal noticeBuilt 1967 · S/N 24-4713 N9218DMaestas Jonathan M · Wright City, MOBuilt 1958 · S/N 22-6278 N9219PChrastka Keith · San Angelo, TXBuilt 1967 · S/N 24-4715 N921BLLewis Bertrand V · Glendale, AZBuilt 1964 · S/N 30558 N9220DEllis Harvey Airport Inc · Guthrie, OKS/N 22-6280

Back to AD 85-02-05 R1