Skip to content

Registered aircraft · 22,416

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:87-08-08-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3') 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:87-08-08-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3')
  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:87-08-08-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3')
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.

N82145Kcn Aero Club Inc · Overland Park, KSBuilt 1980 · S/N 32-8006029 N8214BDaas Company Inc · El Centro, CABuilt 1980 · S/N 32-8006058 N8214EWayland Steven L · Southlake, TXBuilt 1980 · S/N 32R-8029092 N8214HRuetsch Derek R · Goodyear, AZBuilt 1980 · S/N 32R-8029093 N8214NKuenzi Scott A · Madison, WIBuilt 1969 · S/N 28-25418 N8214PVertical Air LLC · Farmington, NMS/N 32R-8029095 N8214QB & B Flying LLC · Green River, WYBuilt 1980 · S/N 32R-8029096 N8214YRegistration Pending · Harrisburg, SDRegistration pendingBuilt 1980 · S/N 28-8090362 N8215NRyder Paul M · Charlotte, NCBuilt 1969 · S/N 28-25419 N82162Conner Larry W · Los Lunas, NMBuilt 1982 · S/N 32R-8313015 N8216NShelton William B · Wildwood, MOBuilt 1969 · S/N 28-25420 N8216SNulton Enterprises LLC · Johnstown, PABuilt 1980 · S/N 28-8016328 N8216TRegistered aircraftBuilt 1982 · S/N 32-8206037 N8216WBritair Inc · Austin, TXBuilt 1965 · S/N 28-2349 N82173Gagnier Hugh K · Hidden Hills, CABuilt 1982 · S/N 32R-8229055 N8217NG U M P S Flying Club Inc · Warner Robins, GABuilt 1969 · S/N 28-25421 N8217QParis Air Inc · Vero Beach, FLBuilt 1980 · S/N 28-8016334 N8217SValles Robert Jr · Spicewood, TXBuilt 1980 · S/N 28-8016335 N8217ZPerry Richard F · Lexington, MABuilt 1982 · S/N 32R-8213051 N8218AFirst Flight Inc · Watertown, CTBuilt 1982 · S/N 32R-8229064 N8218CStargazer Aviation LLC · Clearwater, FLBuilt 1975 · S/N 28-7615081 N8218KN8218k LLC · Chico, CABuilt 1982 · S/N 32R-8229063 N8218NLee David · Palm Springs, CAS/N 28-25548 N8218ZWingsleasing LLC · Wichita, KSBuilt 1980 · S/N 28-8090320 N8219WA18 Missions LLC · Clinton, MOBuilt 1965 · S/N 28-2352 N821BERas Aviation LLC · Elyria, OHBuilt 1978 · S/N 28-7816398 N821FJ8th Dimension Enterprises LLC · Aurora, ORBuilt 2021 · S/N 28020032 N821PASkywest Leasing Inc · St George, UTBuilt 2019 · S/N 2881248 N821PTHermes Ana Paula F · West End, NCFirst renewal noticeBuilt 1973 · S/N 28-7305600 N821RFAlaska Island Air Inc · Togiak, AKBuilt 1989 · S/N 3206053 N82208Bainum Michael Shane · Palestine, TXBuilt 1982 · S/N 28R-8231052 N8220QWallentine Ranch LLC · Dover, DEBuilt 1980 · S/N 32R-8029097 N8220WSb Farms LLC · Bowling Green, OHBuilt 1980 · S/N 32R-8029099 N8221NFedchenko Vitaliy · Cumming, GABuilt 1969 · S/N 28-25425 N82221Hahn Dave · Brooklyn Park, MNBuilt 1980 · S/N 28-8090323 N82226Plane & Pilot News · Ravenna, OHBuilt 1980 · S/N 28-8090324 N8222DPaphos Airways LLC · Farmingdale, NYBuilt 1980 · S/N 28-8016337 N8222FJefferson City Aviation Inc · Jefferson City, MOBuilt 1980 · S/N 28-8016338 N8222HBartek Matthew S · Wylie, TXBuilt 1980 · S/N 28-8016339 N8222JShvetsov Vitaly S · La Canada Flintrid, CABuilt 1980 · S/N 28-8016340 N8222WMitzel Aaron · China Spring, TXBuilt 1965 · S/N 28-2355 N8222YMorale Line Aviation LLC · Albuquerque, NMBuilt 1980 · S/N 28-8090322 N822397 Dolors LLC · Urbana, OHBuilt 1980 · S/N 32-8006059 N8223BRas Aviation LLC · Elyria, OHBuilt 1980 · S/N 28R-8018080 N8223CCurless Timothy A · Demotte, INBuilt 1975 · S/N 28R-7635134 N8223NEvans Jay M · Arrington, TNBuilt 1969 · S/N 28-25427 N8223TTrident Aircraft Leasing LLC · Easton, MDBuilt 1982 · S/N 28-8216170 N82241Naranjo Navarro Jose N · Las Vegas, NVS/N 28-8390018 N8224KPelayes Tristan · Temecula, CABuilt 1982 · S/N 28-8216171 N8224NDc Aviation LLC · Appleton, WIBuilt 1969 · S/N 28-25429

Back to AD 87-08-08 R3