Skip to content

Registered aircraft · 22,413

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.

N2969SJorgensen Richard J · Vail, AZBuilt 1979 · S/N 28-8090013 N2969ZJwest Aero LLC · Smyrna, DEBuilt 1979 · S/N 28R-7931281 N296AREnvation LLC · Winter Haven, FLBuilt 1977 · S/N 32-7840063 N296CAAlice Aviation LLC · Atlanta, GAS/N 28-7415494 N296CBCalifornia Baptist University · Riverside, CABuilt 2018 · S/N 2881008 N296DMDewitt Gary S · Anacortes, WAS/N 28R-7635033 N296HPInnova Air LLC · Encinitas, CABuilt 1996 · S/N 3246059 N296MAHot Wings Aviation LLC · Fishers, INBuilt 2026 · S/N 28020266 N296MGGeorgia Aviation Authority · Eastman, GABuilt 2017 · S/N 2844168 N2970LCgi Transport Inc · Fullerton, CABuilt 1979 · S/N 28R-7931284 N2970NGilcrease Patrick C · Rapid City, SDBuilt 1979 · S/N 28-7911283 N2970RNorwood Norman · Sheridan, WYBuilt 1969 · S/N 28R-35354 N2970TSchieffler Edward H · West Helena, ARBuilt 1979 · S/N 28-7911284 N2971NFull Scale Aviation LLC · Corinth, MSBuilt 1979 · S/N 28-7911288 N2971VSorensen John · Cape May Ch, NJS/N 28-8016001 N2972CHoosier Aviation LLC · Terre Haute, INBuilt 1979 · S/N 28-8016003 N2972RDahl Steven B · Medway, MABuilt 1969 · S/N 28R-35357 N2972YHopkins Larry G · Malabar, FLS/N 28-8016006 N2973KCrown Heights Footcare · Brooklyn, NYS/N 28-8016007 N2973RQuinones Roland · Mckinney, TXS/N 28R-35358 N2973UMobug LLC · Montgomery, TXBuilt 1979 · S/N 28-8016009 N2973WWarrior Aircraft Corp · Sturgis, MIS/N 28-8016010 N2973XJones Jeffrey S · Roseburg, ORBuilt 1979 · S/N 28-8016011 N2973YValiair Limited Co Trustee · Casper, WYBuilt 1979 · S/N 28-8016012 N2974B4m Aircraft Services LLC · Santa Rosa Beach, FLBuilt 1979 · S/N 28-8090020 N2974NDes Moines Flying Club LLC · Indianola, IABuilt 1979 · S/N 28-8090022 N2974TTiger Services Inc · Lawrenceville, GABuilt 1979 · S/N 28-8090024 N2977RRegistered aircraftBuilt 1969 · S/N 28R-35363 N2978RLong Jeffrey K · Bethel Springs, TNBuilt 1969 · S/N 28R-35365 N2979RBecker Joshua · Warrington, PABuilt 1969 · S/N 28R-35366 N297CBCalifornia Baptist University · Riverside, CAS/N 2881917 N297HPCherokee Investments LLC · Monroe, VABuilt 1997 · S/N 3246081 N297MAFlaps 30 Gear Down LLC · Laguna Niguel, CABuilt 1997 · S/N 3246062 N297MGGeorgia Aviation Authority · Eastman, GABuilt 2017 · S/N 2843863 N2980QBlb Aircraft Partners LLC · Wilmington, DES/N 32R-7780274 N2980RSlagle Noah J · Griffin, GABuilt 1969 · S/N 28R-35368 N2982MBergeron John E · Shenandoah, TXBuilt 1977 · S/N 28R-7803158 N2986RArmstrong Dustin L · Hobbs, NMS/N 28R-35375 N2988RSpilman Kathleen M · Mandan, NDBuilt 1970 · S/N 28R-35671 N2989MInternational Air Services Inc Trustee · Carson City, NVBuilt 1977 · S/N 32-7840062 N298ATAltura Holdings LLC · New Albany, MSBuilt 1998 · S/N 3257069 N298HPPendergrass Inc · Demopolis, ALBuilt 1998 · S/N 3246110 N298MGGeorgia Aviation Authority · Eastman, GABuilt 2017 · S/N 2843864 N298PWMedina Ruben F · Foothill Ranch, CABuilt 1965 · S/N 28-20851 N298SHHeising Sean Allen · Billings, MTBuilt 1993 · S/N 3213064 N2992RSolrei Inc · West Palm Beach, FLS/N 28R-35382 N2993RSell Carl N · Spanaway, WABuilt 1969 · S/N 28R-35384 N2994R2994r Aircraft Leasing LLC · Spanish Fork, UTBuilt 1969 · S/N 28R-35386 N2995QTraveling Aviators LLC · West Valley City, UTS/N 32R-7780275 N2995RAbj Aviation LLC · Montgomery, OHBuilt 1969 · S/N 28R-35387

Back to AD 87-08-08 R3