Skip to content

AD 2008-06-28 R1

Registered aircraft · 16,284

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.

N836FSSmart01 LLC · Kissimmee, FLBuilt 1981 · S/N 28-8116200 N8370AIlich Randy Trustee · Ione, CABuilt 1981 · S/N 32R-8129059 N8370YKdtb Investments LLC · Bangs, TXS/N 32R-8129062 N8371BAdams Bryan J · Mesquite, TXBuilt 1981 · S/N 34-8133058 N8372CMarino Robert · Little Neck, NYBuilt 1976 · S/N 28-7690125 N8372UOgopogo Foundation · Sonora, CABuilt 1981 · S/N 34-8133070 N8373CFinley Aviation LLC · Bethel Park, PABuilt 1976 · S/N 28-7690126 N8373DGolden Wings Aviation Inc · Brandenburg, KYBuilt 1981 · S/N 28-8116203 N8373WAmplified Aviation LLC · Cannelburg, INBuilt 1981 · S/N 28-8190214 N8373YArcher Assoc LLC · Ashburn, VABuilt 1981 · S/N 28-8190215 N8375NMackenzie Franklin Arthur III · Lenox, MIBuilt 1981 · S/N 34-8133076 N8376LPray Aviation Inc · Augusta, KSBuilt 1981 · S/N 28-8116205 N83775Mattson Greg L · Alta, IABuilt 1981 · S/N 28-8190220 N8377GKristoferson J S Md Custodian · Denton, TXBuilt 1981 · S/N 32R-8113064 N8377SMiller Devin · Georgetown, TXBuilt 1981 · S/N 34-8133078 N8378ASoutheast Wings Ltd · Winston, GABuilt 1981 · S/N 28-8116206 N8378HDiversified Aeronautical Svcs · Lake Ronkonkoma, NYBuilt 1981 · S/N 28-8116208 N837DD Flight School LLC · Altoona, PABuilt 2024 · S/N 10096 N837DSLyons Brent · Saint Cloud, FLBuilt 2004 · S/N 40.437 N837EFLufthansa Aviation Training USA Inc · Goodyear, AZBuilt 2017 · S/N 2382 N837MMSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2013 · S/N 4022 N837NDUnd Aerospace Foundation · Grand Forks, NDS/N 2881290 N837PProfessional Training Aircraft LLC · Wilmington, DEBuilt 2018 · S/N 2843940 N837SCFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881716 N83808Jcl Aviation Inc · Palm Harbor, FLBuilt 1981 · S/N 32R-8129065 N8380CPittsburgh Pilot Training LLC · Bethel Park, PABuilt 1976 · S/N 28-7690127 N8380LTroser Management Inc · Canandiaigua, NYBuilt 1981 · S/N 28-8190222 N8380PGoins Eric M · Goldsboro, NCBuilt 1981 · S/N 28-8190223 N83814Wachter Bruce · Maryville, TNBuilt 1981 · S/N 28-8116218 N8381CIsley Gaylon B · Cedar Falls, IABuilt 1976 · S/N 28-7690128 N8382AAtd Pilot Training LLC · Kansas City, MOBuilt 1981 · S/N 28-8190228 N83831Connelly Christopher J · Lewiston, NYBuilt 1981 · S/N 28-8190233 N83833Campbell Anna Lu · Sheridan, ILS/N 28-8190234 N8383HAerni Brian S · Columbus, NEBuilt 1981 · S/N 28-8116221 N8383TLoyd Dayton A · Carbondale, ILBuilt 1981 · S/N 28-8116223 N8383VH&M Air LLC · Metamora, MIBuilt 1981 · S/N 28-8116224 N8383ZFreeman Edward B · Killeen, TXBuilt 1981 · S/N 288190229 N8384EG & M Aircraft Inc · Wheat Ridge, COBuilt 1981 · S/N 28-8190236 N8384HTwin Tier Aviation Association Inc · Eldred, PABuilt 1981 · S/N 28-8190237 N8384LMaring Inc · Blaine, MNBuilt 1981 · S/N 32R-8129054 N8386BSprj Aviation LLC · Tampa, FLBuilt 1981 · S/N 32R-8113068 N8386C86 Charlie LLC · Rochester, MNBuilt 1976 · S/N 28-7690134 N8386HSierra Aero · Carson City, NVBuilt 1981 · S/N 32R-8129067 N83882Warrior 83882 LLC · Dover, DES/N 28-8116227 N8388GTrombly Daniel · Franklin, NHBuilt 2003 · S/N 0470 N8388TEmerald Aviation Inc · Miami, FLBuilt 2007 · S/N 2396 N8388YInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N 28-8116226 N8389AJacobus Larry E · Ipava, ILBuilt 1981 · S/N 28-8116228 N838CDQualitair LLC Trustee · MichelstadtBuilt 2002 · S/N 0339 N838CFCherokee Flyers Inc · Vero Beach, FLBuilt 2024 · S/N 2881838

Back to AD 2008-06-28 R1