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.

N30037N30037 LLC · Middletown, DEBuilt 1979 · S/N 32R-7887264 N3003BEhrlich David · Chico, CAS/N 28-7990133 N3003KPayne Michael E · Woodlawn, ILBuilt 1978 · S/N 28-7990243 N3003QTampa Bay Aviation Inc · Clearwater, FLBuilt 1977 · S/N 28-7790430 N3005JPrincipal Management Group LLC · Allentown, PABuilt 2007 · S/N 3232069 N3005KEast Valley Flyers LLC · Chandler, AZBuilt 1978 · S/N 28-7990246 N3005NRoaring Fork Aviation LLC · Snowmass Village, COBuilt 1979 · S/N 28R-7931055 N3005QParadox Designs Inc · Las Vegas, NVBuilt 1979 · S/N 28R-7931024 N3005TSkala Frank M · Wurtsboro, NYS/N 28-7916384 N30063King Air Inc · Naknek, AKBuilt 1978 · S/N 28-7990082 N30067Limbacher John P II · Cookeville, TNBuilt 1978 · S/N 28-7990083 N30069Sky Pilot Aviation Corp · Carlsbad, CABuilt 1978 · S/N 32-7840195 N3006KPrescott Flying Club Inc · South Saint Paul, MNBuilt 1978 · S/N 28-7990247 N3006WJimenez Carlos · Davie, FLBuilt 1979 · S/N 28-7990360 N30074Dunwoody James Robert · Huntsville, ALBuilt 1978 · S/N 32R-7885083 N3007BStanly Business Consultants LLC · Albemarie, NCBuilt 1978 · S/N 28-7990134 N3007KC & B Partnership · Grand Junction, COFirst renewal noticeBuilt 1978 · S/N 28-7990248 N3007THorizon Air Ventures LLC · Fincastle, VABuilt 1997 · S/N 2843072 N30082Burnet Fredrick A · Monticello, UTBuilt 1978 · S/N 32R-7887268 N3008AMackenzie David Webb · Wilmington, DEBuilt 1978 · S/N 28-7916104 N3008BSedberry Jason A DBA · Kokomo, INBuilt 1978 · S/N 28-7990135 N3008FShepherd Michael D · Rock Hill, SCBuilt 1978 · S/N 28-7916210 N3008UNaperville Flying Club Inc · Woodridge, ILBuilt 1979 · S/N 28-7990333 N3009UEdgar Holly A · Tigard, ORBuilt 1979 · S/N 28-7990334 N300BHGreen Valley Corporation I · San Jose, CABuilt 1980 · S/N 32-8006011 N300CACharlie Alpha LLC · Midland, MIBuilt 1973 · S/N 28-7305324 N300CPFuentes John Glen R · Warrenton, VABuilt 1984 · S/N 32R-8413014 N300DBEdeair LLC · Utica, MIBuilt 1979 · S/N 32-7940155 N300DCSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2003 · S/N 2842180 N300DLSanta Barbara Flying Club · Santa Barbara, CABuilt 1978 · S/N 32-7840200 N300DTAlaska Bush Charters LLC · Dillingham, AKBuilt 1978 · S/N 32-7840174 N300EFMrr LLC · Schererville, INBuilt 1977 · S/N 28-7715267 N300HVBaja Flyers Corp Inc · San Diego, CABuilt 1971 · S/N 32-7140026 N300JPRedd James P Trustee · Eureka, CABuilt 1969 · S/N 32-40597 N300KRWisconsin Aviation-Four Lakes Inc · Madison, WIBuilt 1976 · S/N 28R-7635210 N300LGSmith Foster F · Bishopville, SCBuilt 1980 · S/N 32-8024023 N300PAAero Maintenance Inc · Vancouver, WABuilt 1974 · S/N 28R-7435206 N300RJTcj Kqc LLC · Robstown, TXBuilt 1976 · S/N 32R-7680286 N300RMHiscall Enterprises Inc · Dickson, TNBuilt 1970 · S/N 32-7140003 N300UBoard Of Regents Of The Univeristy Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020226 N300UMMurray Air LLC · Patoka, ILBuilt 1982 · S/N 32R-8213043 N300VMDavis Laramie · Canyon, TXBuilt 1976 · S/N 32R-7780120 N300WEK & S Aero LLC · West Chester, PABuilt 1979 · S/N 32R-7985007 N300WLRosen Robert D · Lewisville, NCBuilt 1977 · S/N 32R-7780474 N300WYChupka William J · Riverton, WYBuilt 1965 · S/N 28-21280 N3010ELenzen Richard D Dr · Antioch, ILBuilt 1978 · S/N 28-7916167 N3010KGoodwin David · Edinburg, NYBuilt 1978 · S/N 28-7911086 N3010TBb Air Corp · Tulsa, OKBuilt 1979 · S/N 32-7940060 N3010WSunwest Aviation Inc · Santa Ynez, CABuilt 1995 · S/N 28-43016 N3010YPn4 Aviation Holdings LLC · Bishop, CABuilt 1979 · S/N 28R-7931151

Back to AD 87-08-08 R3