Skip to content

Registered aircraft · 2,375

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:82-06-11-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:82-06-11-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:82-06-11-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:82-06-11-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:82-06-11-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:82-06-11-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.

N3569QTerry Woodard Enterprises Inc · Beaumont, TXBuilt 1977 · S/N 28R-7703115 N3574QOlson LLC · Newberg, ORS/N 28R-8031040 N3585MHanlin Dale E · Porter, TXBuilt 1978 · S/N 28R-7837126 N3587MWellspring Air Group LLC · East Helena, MTBuilt 1978 · S/N 28R-7803179 N3588MCavu Aviation LLC · Draper, UTBuilt 1978 · S/N 28R-7803180 N3589MGregory Kenneth C · Gilbert, AZBuilt 1978 · S/N 28R-7803181 N36024Walla Walla University · College Place, WABuilt 1978 · S/N 28R-7837262 N36067Armor Corps Inc · Spring Hill, TNBuilt 1978 · S/N 28R-7803309 N36096Miami Arrow LLC · Peru, INBuilt 1978 · S/N 28R-7837265 N36097Conner Don R · Hot Springs, SDFirst renewal noticeS/N 28R-7803310 N36120United States Air Force Owner · Hanscom Afb, MABuilt 1978 · S/N 28R-7837266 N36282Beverly Flight Center LLC · Danvers, MABuilt 1978 · S/N 28R-7837271 N3630MAmercani Mahmoud · Fayetteville, GABuilt 1978 · S/N 28R-7803182 N3631MTrekjet LLC · Southington, CTBuilt 1978 · S/N 28R-7803183 N36384Lisa Rocco J · Elkhart, INBuilt 1978 · S/N 28R-7837277 N36496Moseler Scott · Barrington, ILBuilt 1978 · S/N 28R-7803326 N36574California In Nice Inc · San Jose, CABuilt 1978 · S/N 28R-7837284 N36619Gipson Ronnie R · Carlisle, PABuilt 1978 · S/N 28R-7837286 N3661MAlpha Kilo Enterprises LLC · Helena, MTBuilt 1978 · S/N 28R-7837129 N3664MEchtle Keith A · Castroville, TXBuilt 1978 · S/N 28R-7803184 N366LCLane Community College · Eugene, ORBuilt 1981 · S/N 28R-8218005 N36749Air Smt LLC · Powell, OHBuilt 1978 · S/N 28R-7837291 N36777Litwin Linda J · Potomac, MDBuilt 1978 · S/N 28R-7837292 N36802United States Air Force- Owner · Hanscom Afb, MABuilt 1978 · S/N 28R-7837293 N36804Poplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1978 · S/N 28R-7837295 N36822Bream Bruce L · Beachwood, OHBuilt 1978 · S/N 28R-7803345 N36838Sapphire Air LLC · Keystone, COBuilt 1978 · S/N 28R-7837296 N3700QGorge Winds Aviation Inc · Fairview, ORS/N 28R-7737047 N3704MLacroix Robert Emile Jr · Orlando, FLS/N 28R-7837130 N3730MWilcom LLC · Hammond, LABuilt 1978 · S/N 28R-7837133 N3731MZim Air LLC · Wilmington, DEBuilt 1978 · S/N 28R-7803189 N373CBCalifornia Baptist University · Riverside, CABuilt 2017 · S/N 2844174 N373PFSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1980 · S/N 28 R 801 8040 N3745QBeer Aviation LLC · Santa Rosa Beach, FLS/N 28R-7737058 N374CBCalifornia Baptist University · Riverside, CABuilt 2017 · S/N 2844175 N3755QNarwhal Airlines LLC · Odessa, TXS/N 28R-7703116 N3765MReyner Mark D · Los Lunas, NMBuilt 1978 · S/N 28R-7803191 N377LCLane Community College · Eugene, ORS/N 28R-7918120 N378RSKempton Larry J III · Grand Junction, COBuilt 1978 · S/N 28R-7837239 N3796MRoth Jacques A · San Rafael, CABuilt 1978 · S/N 28R-7803194 N37KSNarwani Anil V · Orlando, FLBuilt 1977 · S/N 28R-7703257 N3811MBanks Jerry A · Collierville, TNBuilt 1969 · S/N 28R-35200 N38123Huber Weylin L · Aberdeen, SDBuilt 1977 · S/N 28R-7703178 N38200Hauzer Alex · Golden, COBuilt 1977 · S/N 28R-7737083 N38201Touchstone Justin Reed · Hattiesburg, MSS/N 28R-7703188 N38203Wdiaz Design Inc · Sunny Isles Beach, FLBuilt 1977 · S/N 28R7703189 N38256Ringler Neil H · Baldwinsville, NYBuilt 1977 · S/N 28R-7737085 N38273Southern Aircraft Consultancy Inc Trustee · Casper, WYS/N 28R-7737086 N38275Von Duyke Mark A · Des Moines, WABuilt 1977 · S/N 28R-7703198 N38294Aerograzmar LLC · Bloomfield, NJBuilt 1977 · S/N 28R-7737087

Back to AD 82-06-11 R1