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.

N809RJViewpoint Management LLC · Atlanta, GABuilt 2005 · S/N 1361 N809TFAir Fleet Holdings LLC · Missoula, MTBuilt 2024 · S/N 2881702 N80AJCirrus Design Corp · Duluth, MNS/N 11697 N80BTCentral Virginia Aviation Inc · Petersburg, VABuilt 1975 · S/N LW-148 N80CDCsb Capital LLC · Swisher, IABuilt 2001 · S/N 0075 N80CPBf Air LLC · Panama City, FLBuilt 1977 · S/N BB-263 N80DJShireman Kirk A · Pearland, TXBuilt 1981 · S/N 32R8129081 N80FBPhronesis Enterprises Too LLC · Houston, TXBuilt 2004 · S/N 1054 N80FGFlightgest Academy LLC · Morrisville, NCBuilt 2022 · S/N 2881562 N80FTWifa (Washington International Flight Academy) LLC · Gaithersburg, MDBuilt 2000 · S/N 2842078 N80GDBlanchard Joshua A · Greenville, MIBuilt 2006 · S/N 1672 N80NSSch Aviation Inc Trustee · Sporle Kings LynnBuilt 2007 · S/N 2839 N80RLGree LLC · Hobbs, NMBuilt 2014 · S/N 4636646 N80VJEkman Evan F · Chapin, SCBuilt 2016 · S/N 2318 N80VTCarr Christopher Wren · Eagle Point, ORBuilt 2007 · S/N 2560 N80WHSchuylkill Seaplanes LLC · Newtown Square, PABuilt 2025 · S/N 10952 N80WMAt Aero LLC · Wilmington, DES/N BB-863 N81006Wicked Wings LLC · Norwood, NCBuilt 1979 · S/N 32R-8013010 N81013Saratoga N81013 LLC · Santa Rosa Beach, FLBuilt 1979 · S/N 32R-8013013 N81014Beccario Joseph P · Sault Sainte Marie, MIBuilt 1979 · S/N 28-8090112 N81016Lane Community College · Eugene, ORBuilt 1979 · S/N 28-8016095 N8101DZambrano Holdings LLC · Port Orange, FLBuilt 1979 · S/N 44-8095003 N81021Paris Air Inc · Vero Beach, FLBuilt 1979 · S/N 28-8016106 N81023Boettinger John G · Oak Lawn, ILBuilt 1979 · S/N 28-8016108 N81024Jonsson Erik · Twin Falls, IDBuilt 1979 · S/N 28-8016109 N8102BDayton Stephen · Littleton, NHS/N 28-8016099 N8102HEklof Gary L · Wayzata, MNBuilt 1979 · S/N 28-8016101 N8102SJl Holdings Ntx LLC · Flower Mound, TXBuilt 1979 · S/N 28-8016104 N81034Registered aircraftBuilt 1979 · S/N 28-8090120 N81036Precision Aviation LLC · Fayetteville, GABuilt 1979 · S/N 28-8090121 N8103HAlleghany Flying Club Inc · Hyndman, PABuilt 1979 · S/N 28-8090116 N8103QFlight Time Builders Inc · Memphis, TNBuilt 1979 · S/N 28-8090117 N810AM5280 Flying Club LLC · Castle Pines, COBuilt 2022 · S/N 2881578 N810ATDot Aviation LLC · Wilmington, DEBuilt 2014 · S/N 4496367 N810DAMjh Aero Inc · Houston, TXBuilt 1978 · S/N 28-7816427 N810KCBlocker Cale · Savannah, GABuilt 1981 · S/N 32R-8129050 N810MKK4 Transportation LLC · Lapeer, MIBuilt 2025 · S/N 10786 N810NKAims Community College · Greeley, COBuilt 2020 · S/N 2881344 N810PTWroblewski Andrzej Marek · Edgewater, MDBuilt 2002 · S/N 0331 N810RTStratus Air Services LLC · Canyon Country, CABuilt 2021 · S/N 2718 N810UBoard Of Regents Of University Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020230 N810WWOld Moreland LLC · Daniel Island, SCBuilt 2020 · S/N 4955 N8110FRobinson Ronald G · Ottawa, ILBuilt 1976 · S/N 28-7790234 N8112CMidili Aldo D · Volcano, CAS/N 28-8016114 N8112JRamsey Douglas Edward · Monument, COBuilt 1979 · S/N 28-8090124 N8112QLongbranch Av8r LLC · Santa Rosa Beach, FLBuilt 1979 · S/N 28-8090125 N81133Rafiq Abrahem · San Diego, CABuilt 1979 · S/N 28-8090133 N8113BCapitol City Flyers Inc · Madison, WIS/N 28-8090128 N8113HT4 Aviation LLC · Nine Mile Falls, WABuilt 1979 · S/N 28-8090129 N8113KSalmon River Assets LLC · The Woodlands, TXBuilt 1979 · S/N 28-8090130

Back to AD 2008-06-28 R1