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.

N8024QFox Leasing Group LLC · Hollywood, FLBuilt 2021 · S/N 4496519 N8025CLaabs Fran C · Ames, IABuilt 1954 · S/N 22-2212 N8026CWyatt Gaylon J · Pineville, ARBuilt 1954 · S/N 22-2213 N8026YCaillouet Andre E Jr · Houma, LABuilt 1966 · S/N 30-1135 N8027YGreek Housing Services Corp · Port Matilda, PABuilt 1966 · S/N 30-1084 N8028CLisk Justin T · Rhodes, IABuilt 1954 · S/N 22-2215 N8028PTrest Robert J · Pelzer, SCBuilt 1962 · S/N 24-3274 N8029CFlying Zoo LLC · Collinston, UTBuilt 1954 · S/N 22-2216 N8029PLong Trevor J · Flower Mound, TXS/N 24-3275 N802ATFlight School Of Texas LLC · Wilmington, DEBuilt 2013 · S/N 4496330 N8030YPaden Frank G · Lawrenceburg, KYBuilt 1966 · S/N 30-1139 N8031POphus Larry N · Big Sandy, MTBuilt 1962 · S/N 24-3278 N8031YBresin Sharon M · Kamas, UTS/N 30-1140 N8032PMorrison Danny G · Louisburg, KSBuilt 1963 · S/N 24-3279 N8033DLevinson Alan J · Delta Junction, AKBuilt 1957 · S/N 22-5558 N8034DMyers Mark · Clovis, NMBuilt 1957 · S/N 22-5559 N8034YBerry James V DBA · Hermosa Beach, CABuilt 1966 · S/N 30-1143 N8035DSchulz Garth · Anchorage, AKBuilt 1957 · S/N 22-5560 N8035PKohler Richard L · Moriarty, NMBuilt 1962 · S/N 24-3282 N8035YJakowiw Nicholas · Clifton Park, NYBuilt 1966 · S/N 30-1144 N8037CLugten Jerry L · Leslie, MIBuilt 1954 · S/N 22-2224 N8037YTolleson Darrin L · North Liberty, INBuilt 1966 · S/N 30-1147 N8038CFrench Christopher K · Tehachapi, CAS/N 22-2225 N8038PWeaver Chris DBA · Hallam, NEBuilt 1962 · S/N 24-3158 N8039CMatthew Karson Tyler · Lone Wolf, OKBuilt 1954 · S/N 22-2226 N8039DUllrich Sandy J · Haskell, OKS/N 22-5563 N803AWiechmann Caleb J · Prairie City, SDS/N 22-106 N803ATFlight School Of Texas LLC · Wilmington, DEBuilt 2013 · S/N 4496332 N8040DReboot Charity Inc · West Palm Beach, FLBuilt 1957 · S/N 22-5565 N8041PEnsign James P · N Richlnd Hls, TXBuilt 1962 · S/N 24-3285 N8042DYounger Tyler J · Bakersfield, CABuilt 1957 · S/N 22-5567 N8043PGray Motors Inc · Port Angeles, WABuilt 1962 · S/N 24-3289 N8043YN56453 LLC · Bowie, MDBuilt 1966 · S/N 30-1154 N8044DGillen Sean P · Arlington, TXBuilt 1957 · S/N 22-5569 N8045CConrad Daniel R · Sweet Home, ORBuilt 1954 · S/N 22-2231 N8045DLarson Larry E · Twin Valley, MNBuilt 1957 · S/N 22-5570 N8045NCti Aircraft Leasing LLC · Memphis, TNBuilt 2019 · S/N 4496488 N8045PDuncan Mark L · Hyampom, CABuilt 1962 · S/N 24-3291 N8046NSwett Frank M · Zebulon, NCS/N 22-748 N8047DMurphy Robert · Kent, WABuilt 1957 · S/N 22-5572 N8048PCoastal Virginia Aviation LLC · Chesapeake, VABuilt 1962 · S/N 24-3293 N8049DFerrell Alan B · Arlington, OHBuilt 1957 · S/N 22-5573 N804ATFlight School Of Texas LLC · Wilmington, DEBuilt 2013 · S/N 4496333 N8050DSalerno Joseph C Jr · Gettysburg, PAFirst renewal noticeBuilt 1957 · S/N 22-5574 N8050YGmm Records · Big Pine Key, FLBuilt 1962 · S/N 27-2098 N8051PReeder Blake · Amarillo, TXS/N 24-3297 N8052AChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 4496461 N8052DObowa Denis J · Fergus Falls, MNBuilt 1957 · S/N 22-5578 N8052PCornerstone Dec Ltd · Chico, CABuilt 1962 · S/N 24-3298 N8052YSix Drew · New Franklin, OHBuilt 1966 · S/N 30-1165

Back to AD 85-02-05 R1