Skip to content

AD 2008-06-28 R1

Registered aircraft · 16,280

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

N2BG2fly LLC · Seattle, WABuilt 2009 · S/N 3458 N2ESBuilding Solutions LLC · West Palm Beach, FLBuilt 2006 · S/N 41672 N2FTContemporary Aviation LLC · Excelsior, MNBuilt 2024 · S/N 10307 N2JZFairwinds Flight LLC · Bloomington, MNBuilt 2008 · S/N 4697368 N2MAFlorida Air Leasing LLC · Gainesville, FLBuilt 2004 · S/N 1177 N2NQSurdex Corp · Chesterfield, MOBuilt 1982 · S/N 441-0307 N2PWXin Han Aviation LLC · Atwater, CABuilt 1979 · S/N 44-7995087 N2PXBliss James · Corpus Christi, TXBuilt 1977 · S/N 28-7816211 N2UNSuriel Darleny G · New York, NYBuilt 1969 · S/N 28R-31080 N2ZHClt Thompson Holdings LLC · Charlotte, NCBuilt 2001 · S/N 0056 N30009Mock Joseph R · Huntsville, TXBuilt 1978 · S/N 28-7816539 N3000DHungy Air LLC · Bettendorf, IABuilt 2001 · S/N 0083 N30012Wfc Aviation Inc · Johnstown, PABuilt 1978 · S/N 28-7916073 N30015N30015 LLC · Saunderstown, RIBuilt 1978 · S/N 28-7990079 N3001KHauck Drew Steven · Buffalo, MNBuilt 1978 · S/N 28-7990241 N3001TSluka Christopher J · San Diego, CABuilt 1979 · S/N 28-7990319 N3001WLexington Flying Club Inc · Lexington, KYBuilt 1979 · S/N 28-7990356 N30020Frieders Farm Corp · Waterman, ILBuilt 1978 · S/N 28-7990080 N30028Cc Aviation Inc · Tracy, CAS/N 34-48019 N3002BDenton Charles W · San Juan, PRBuilt 1978 · S/N 28-7916123 N3002MHarth Kai H · Manassas, VABuilt 1978 · S/N 28-7816327 N30034Archer 30034 LLC · Ray Township, MIS/N 2843576 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 N3005DAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 1978 · S/N 44-7995140 N3005JPrincipal Management Group LLC · Allentown, PABuilt 2007 · S/N 3232069 N3005KEast Valley Flyers LLC · Chandler, AZBuilt 1978 · S/N 28-7990246 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 N3006KPrescott Flying Club Inc · South Saint Paul, MNBuilt 1978 · S/N 28-7990247 N3006WJimenez Carlos · Davie, FLBuilt 1979 · S/N 28-7990360 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 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 N300CPFuentes John Glen R · Warrenton, VABuilt 1984 · S/N 32R-8413014 N300DCSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2003 · S/N 2842180 N300SUOklahoma State University · Stillwater, OKBuilt 2019 · S/N 2520 N300UBoard Of Regents Of The Univeristy Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020226 N300WJAthens Aviation LLC · Wilmington, DEBuilt 1977 · S/N BB-319 N30101Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 44-7995069 N3010ELenzen Richard D Dr · Antioch, ILBuilt 1978 · S/N 28-7916167 N3010WSunwest Aviation Inc · Santa Ynez, CABuilt 1995 · S/N 28-43016 N30114International Aviation Group LLC · Lake Wales, FLBuilt 1978 · S/N 28-7916076

Back to AD 2008-06-28 R1