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.

N7939WCaviation LLC · Columbus, NES/N 28-1981 N793AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843796 N793CAChristiansen Aviation LLC · Wilmington, DEBuilt 2024 · S/N 2881765 N7940NCloudburst Resources Inc · Lavonia, GABuilt 1969 · S/N 28-5355 N7940WMurray Air LLC · Patoka, ILS/N 28-2051 N7941NHonke Richard · Lake Andes, SDBuilt 1969 · S/N 28-5356 N7941WHansen Brandon C · Hyde Park, UTBuilt 1964 · S/N 28-1982 N7942CN4143w LLC · Los Gatos, CABuilt 1975 · S/N 32R-7680069 N7943WBlue Ridge Aviation Services LLC · Ridgeway, VABuilt 1964 · S/N 28-1985 N7944CAugter Gary K · Mcalester, OKS/N 28-7690091 N7944NInspire Aviation LLC · Magnolia, TXBuilt 1969 · S/N 28-5360 N7944WPadisak Michael · Traverse City, MIBuilt 1964 · S/N 28-1987 N7945NWittenbrader Jeffrey M · Lake Ariel, PABuilt 1969 · S/N 28-5361 N7945WOnward Enterprises LLC · Laurel, MSBuilt 1964 · S/N 28-1989 N7946NSommer Matthew D · Whiteford, MDBuilt 1969 · S/N 28-5362 N7946WCushman Jeffrey R · Superior, WIBuilt 1964 · S/N 28-1990 N7948NHayes William B · Saint Charles, MOBuilt 1969 · S/N 28-5364 N7948WCruse Billy · North Bend, WAFirst renewal noticeS/N 28-1992 N7949NGuess-Slatosky Carrie · Randleman, NCBuilt 1969 · S/N 28-5365 N794AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843797 N794BKMaxlines LLC · Fairfax, CABuilt 1979 · S/N 28-7916556 N7951CJaybec Corp · Pinecrest, FLBuilt 1975 · S/N 32R-7680070 N7951F1world Aero LLC · Fort Meade, MDBuilt 1976 · S/N 28-7715249 N7951WHerman Eric M · Hugo, MNBuilt 1964 · S/N 28-1998 N7952CKramer Kartie K · Mckinney, TXBuilt 1975 · S/N 32R-7680071 N7953CFox Victor Aircraft & Sales LLC · Lebanon, TNBuilt 1975 · S/N 28-7625090 N7953WMcdaniel James D · Ortonville, MIBuilt 1964 · S/N 28-2001 N7954JSouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 28R-7635125 N7954NW8s Enterprises LLC · Stillwater, OKBuilt 1969 · S/N 28-5370 N7955NByrne Daryl K · Eagle, IDBuilt 1969 · S/N 28-5371 N7955WLucas William J · Cochran, GABuilt 1964 · S/N 28-2003 N7956WBartlett Henry D · Colorado Springs, COBuilt 1964 · S/N 28-2005 N7957WKendry Shane Joseph · Panama City, FLBuilt 1964 · S/N 28-2006 N7959WNorman Jeremy J · Morgantown, WVBuilt 1964 · S/N 28-2008 N795CWNemish John M · Suffolk, VABuilt 1964 · S/N 28-2002 N7960NJenkins James Randal · Yukon, OKBuilt 1969 · S/N 28-5376 N7961NRegistered aircraftBuilt 1969 · S/N 28-5377 N7961WMoore Donald A · Livingston, MTBuilt 1964 · S/N 28-2010 N7962NFisher Albert Lee III · Oshkosh, WIBuilt 1969 · S/N 28-5378 N7962WHoffman Donald A · Boynton Beach, FLBuilt 1964 · S/N 28-2011 N7963FMacair Aviation LLC · Xenia, OHBuilt 1976 · S/N 28-7715251 N7963NJohnson Dennis E · Factoryville, PABuilt 1969 · S/N 28-5379 N7963WRichardson Douglas M · Westminster, COBuilt 1964 · S/N 28-2012 N7964NLoar Kenneth Joseph Jr · Mundelein, ILBuilt 1969 · S/N 28-5380 N7964WYambor Aaron Casimir · Bowling Green, OHBuilt 1964 · S/N 28-2014 N7965FLustig Barry J · San Ramon, CABuilt 1976 · S/N 28-7790229 N7965NArnold Milton E · Becket, MABuilt 1969 · S/N 28-5381 N7966NWest Timothy A · Marion, KYBuilt 1969 · S/N 28-5382 N7967CDeer Park Air Center LLC · Deer Park, WABuilt 1975 · S/N 28-7690094 N7967NMorales Jesus L · San Antonio, TXS/N 28-5383

Back to AD 87-08-08 R3