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.

N75GSBright Sky LLC · Orwigsburg, PABuilt 1974 · S/N 28-7405211 N75JEHammer Motion Pictures Inc · Indianapolis, INBuilt 1975 · S/N 32-7540164 N75RESarasota Wings LLC · Nokomis, FLBuilt 1982 · S/N 32-8206031 N75SGW E Love Ranch · Marfa, TXBuilt 2000 · S/N 3257175 N7600WWeigley Kasey Jo · Graham, WABuilt 1964 · S/N 28-1559 N7601WMartinez Frank M · Folsom, CABuilt 1964 · S/N 28-1560 N7602JGarrison Rodney Lynn · Atlanta, TXS/N 28R-30994 N7603JMcclain Thomas J · Toledo, OHBuilt 1968 · S/N 28R-30995 N7603WBe Properties II LLC · North Platte, NEBuilt 1964 · S/N 28-1562 N7605WBrownlow Gail L · Mountain City, TXBuilt 1964 · S/N 28-1564 N7606CKuuluka LLC · Lewes, DEBuilt 1975 · S/N 32R-7680048 N7606JLiburd Edison V · Austell, GABuilt 1968 · S/N 28R-30920 N7606WOlsen Michael D · Woodinville, WABuilt 1964 · S/N 28-1565 N7607JMoser Robert W · Flower Mound, TXBuilt 1968 · S/N 28R-30936 N7608JGevry Ronald Joseph Jr · Alpharetta, GABuilt 1968 · S/N 28R-30999 N7609JMcmaster William Timothy · Hanford, CABuilt 1968 · S/N 28R-31001 N7609WTaylor Samuel W · Kansas City, MOBuilt 1964 · S/N 28-1568 N760C2nd Amendment Wholesale Inc · Grand Forks, NDBuilt 2008 · S/N 3257488 N760MASandpiper Air LLC · Elizabeth City, NCBuilt 2000 · S/N 3246160 N760PSEagle Squadron Inc · The Villages, FLBuilt 1976 · S/N 32R-7680342 N760UOhio University · Albany, OHBuilt 2005 · S/N 2842231 N760WParagon Airplane Leasing Co · Fort Myers, FLBuilt 2024 · S/N 28020181 N7610JDelci Dino J · Tempe, AZBuilt 1968 · S/N 28R-31002 N7610WMeier Michael D · Naubinway, MIBuilt 1964 · S/N 28-1569 N7611WRace Place Inc · Greenwood, INBuilt 1964 · S/N 28-1571 N7612JSpeer Aviation LLC · Live Oak, FLBuilt 1968 · S/N 28R-30801 N7612WGunn Michael Reid · Wilson, ARBuilt 1964 · S/N 28-1572 N7614JN7614j LLC · Berkeley Heights, NJBuilt 1968 · S/N 28R-31006 N7614WFerris Lawrence D · Valentine, NEBuilt 1964 · S/N 28-1575 N7615JAll American Aviation Services Inc · Fayetteville, NCBuilt 1968 · S/N 28R-31008 N7615WBittner Terry L · Woodbine, MDBuilt 1964 · S/N 28-1576 N7616FBurgers Todd · Lagrange Hlds, ILBuilt 1976 · S/N 28-7715210 N7616JThigpen Kevin · Jacksonville, FLBuilt 1968 · S/N 28R-31009 N7617FKeldahl William J · Copperhill, TNBuilt 1976 · S/N 28-7715211 N7617JMilner Quinn D · Carbondale, ILBuilt 1968 · S/N 28R-31010 N7617WWhirl'D Helicopters Inc · Sevierville, TNBuilt 1964 · S/N 28-1581 N7618WExaltium Aviation LLC · Baltimore, MDBuilt 1964 · S/N 28-1582 N7619FAinsworth Cavin · Fort Towson, OKBuilt 1976 · S/N 28-7790194 N761CAChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 2881738 N761CCHesston College Aviation · Hesston, KSBuilt 1976 · S/N 28-7690288 N761RBBastin Robet J · Cadiz, KYBuilt 1999 · S/N 3257107 N7620FRed 5 LLC · Kalispell, MTFirst renewal noticeBuilt 1976 · S/N 28-7790195 N7621FMeier Scott F · Jupiter, FLBuilt 1976 · S/N 32-7700006 N7621WAlexander Steven W · Kansas City, MOBuilt 1965 · S/N 28-2913 N7622FAeronation Aircraft & Exotics LLC · Lewes, DES/N 32R-7780065 N7622JSkylink Aviation Inc · Florissant, MOBuilt 1968 · S/N 28R-31017 N7622WBarnett Donald R · Atoka, TNBuilt 1964 · S/N 28-1586 N76235Kirby Coray S · Newton, NJS/N 28-7610138 N7623JWhite Jeffrey M · Carlsbad, CAS/N 28R-31018 N7623WMidwest Heavy Construction LLC · Pleasant Hill, MOBuilt 1964 · S/N 28-1587

Back to AD 87-08-08 R3