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.

N478DSChucktown Flight Training LLC DBA · Summerville, SCBuilt 2012 · S/N 40.1169 N478GRabkin John M · Portland, ORBuilt 2004 · S/N 1227 N478KMFly Global LLC · Columbus, GABuilt 2017 · S/N 4533 N478MDAirmart Inc · Lexington, KYBuilt 2005 · S/N 3257376 N478MPTetonville LLC · Charlottesville, VABuilt 2009 · S/N 3470 N478PCSaint Louis University · Saint Louis, MOBuilt 2019 · S/N 2881201 N478SEGarber William · Apollo Beach, FLFirst renewal noticeBuilt 2004 · S/N 1158 N478SROutside In Aviation LLC · Fort Madison, IABuilt 2006 · S/N 2009 N47905Hanson Larry A · Starkville, MSBuilt 1977 · S/N 28-7816155 N47906Brooks Jerry D · Fairmont, MNBuilt 1977 · S/N 28-7816156 N47907Macaulay Mark · Austin, TXBuilt 1977 · S/N 28-7890150 N47918Hay Yotam · Johnson City, TNBuilt 1977 · S/N 28-7816158 N47920Barbeau Daniel P · Tullahoma, TNBuilt 1977 · S/N 28-7816160 N47923Stoehr Steven C Trustee · Ewing, NES/N 28-7890153 N47924Laplant Lloyd P Jr · El Cajon, CABuilt 1977 · S/N 28-7890154 N47929Hylton Fitzroy C · Miramar, FLFirst renewal noticeBuilt 1977 · S/N 28-7816161 N47941Engineering Forensics Inc · Glen Burnie, MDS/N 28-7816167 N47943Louiewex Corp · Dover, DES/N 28-7890157 N47953Mountain Aviation Associates LLC · Midland, TXBuilt 1977 · S/N 28-7816169 N47954Jennings James A · Fredericktown, OHS/N 28-7816170 N47955Southeastern Minnesota Flying Club Inc · Rochester, MNBuilt 1977 · S/N 28-7890159 N47965Reid Brian M · Boise, IDS/N 28-7890156 N47968Grimes Mike · Yukon, OKBuilt 1977 · S/N 28-7816173 N47969Thomason Eric A · Georgetown, TXBuilt 1977 · S/N 28-7816174 N47971Five X Five Flight Inc · The Woodlands, TXBuilt 1977 · S/N 28-7890163 N47981Sabetha Flyers Inc · Sabetha, KSBuilt 1977 · S/N 28-7890164 N47995Raab David A · York, PABuilt 1977 · S/N 28-7890168 N479AVWestwind School Of Aeronautics Phoenix LLC · Goodyear, AZBuilt 2023 · S/N 9180 N479DAAerosim Academy Inc · Sanford, FLBuilt 2007 · S/N 1821 N479DS7911 Airways LLC · Philadelphia, PABuilt 2013 · S/N 40.1189 N479JAYale Companies LLC DBA · Indianapolis, INBuilt 2022 · S/N 28020079 N47AM2 Point Aviation LLC · Colorado Springs, COBuilt 2000 · S/N 1054 N47AWN47aw LLC · Baton Rouge, LAS/N 10089 N47BNCavorite Aviation LLC · Lehi, UTBuilt 1995 · S/N 28-43020 N47DWN47dw LLC · Camden, DES/N 4636763 N47ER15 East Management Inc · Wake Forest, NCBuilt 2002 · S/N 4636340 N47FAAshe Olen Reid Jr Trustee · Winston Salem, NCBuilt 2004 · S/N 0965 N47HPBuddy Air LLC · West Bend, WIS/N 4697201 N47LHPompano Senior Squadron Flying Club Inc · Pompano Beach, FLBuilt 1979 · S/N 28-7990480 N47LULetourneau University · Longview, TXBuilt 2017 · S/N 4496416 N47MRFree Bird Aviation LLC · Wasilla, AKFirst renewal noticeS/N 41057 N47SAValiair Lc Trustee · Casper, WYBuilt 2024 · S/N 9759 N47SRRendezvous T82 LLC · Mansfield, TXS/N 1418 N47TPMccreery Aviation Co Inc · Mcallen, TXBuilt 2010 · S/N 2037 N47VUDss Air LLC · Jefferson, GABuilt 2018 · S/N 2445 N47ZZCasas De Clark LLC · Burnet, TXBuilt 2020 · S/N 2648 N4802JSwaz Aviation LLC · Mesa, AZBuilt 1968 · S/N 28R-30603 N4806FSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2001 · S/N 4496095 N480BLDoctor Blue Eyes LLC · Princeton, WVBuilt 1980 · S/N 32R-8029105 N480CATyne Aviation LLC · Nashville, TNBuilt 2007 · S/N 4636414

Back to AD 2008-06-28 R1