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.

N8414M8414m LLC · Nunica, MIBuilt 1981 · S/N 28-8190276 N8414NAirlake Aero Inc · Lakeville, MNBuilt 1981 · S/N 28-8190278 N8414YLone Oak Aviation LLC · Greenville, NCBuilt 1981 · S/N 28-8190279 N8415FGrediagin Wayne · Anchorage, AKBuilt 1981 · S/N 32R-8113088 N8415HAeronautica Aviation Inc · Port Orange, FLBuilt 1981 · S/N 32R-8113092 N8416K8090 Alpha LLC · Grayslake, ILBuilt 1981 · S/N 32R-8113093 N84175Paris Air Inc · Vero Beach, FLS/N 288116274 N84176Brandywine Flight School · West Chester, PABuilt 1981 · S/N 28-8116275 N8417AGate 13 LLC · Santa Fe, NMBuilt 1981 · S/N 34-8133175 N8417HWalser Air LLC · Warwick, RIBuilt 1981 · S/N 34-8133178 N8419HHoke William Jr · Charlestown, INBuilt 1981 · S/N 28-8190291 N841ATLuxury Transportation LLC · Talladega, ALBuilt 2004 · S/N 3257352 N841CBrown'S Aviation LLC · Whitesburg, GAS/N 0409 N841CDAir Horacio LLC · Dover, DES/N 0336 N841DSCobalt Aero LLC · Albany, GABuilt 2007 · S/N 40.881 N841EFLufthansa Aviation Training USA Inc · Goodyear, AZBuilt 2018 · S/N 2395 N841KYPinaire Holdings LLC · Hendersonville, TNS/N BB-841 N841NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2020 · S/N 2881308 N841TStief Todd Foster · Mount Pleasant, SCBuilt 2007 · S/N 1806 N841WMBoard Of Trustees Of Western Michigan Univeristy · Kalamazoo, MIBuilt 2024 · S/N 10222 N8420CRegistered aircraftBuilt 1976 · S/N 28-7690138 N84227Jernigan Alex E · Warrensburg, MOBuilt 1981 · S/N 28-8190298 N8422HDeevers Howard A · Tucson, AZBuilt 1981 · S/N 28-8116292 N8422NCenter Flying Inc · Lancaster, CABuilt 1981 · S/N 28-8190296 N84235Klj Air LLC · Fairless Hills, PABuilt 1981 · S/N 32R-8113098 N8423AWinningham Artis R · Crossville, TNS/N 28-8190299 N8424ATringale Alison · Port Saint Joe, FLBuilt 1981 · S/N 32R-8129092 N8425HJohansen Herbert J · Bennington, NEBuilt 1981 · S/N 32R-8113099 N8425PSaratoga 25 Papa LLC · Carmel, INBuilt 1981 · S/N 32R-8113101 N8425TN93lv LLC · Lancaster, PABuilt 1981 · S/N 32R-8113102 N84263Chadwick James B · Rch Palos Vrd, CABuilt 1981 · S/N 32R-8129094 N8426GWisconsin Aviation Inc · Watertown, WIBuilt 1981 · S/N 34-8133195 N8427GWarrior II Ltd · Des Plaines, ILBuilt 1981 · S/N 28-8116297 N8427KInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N 28-8116299 N8427TPierce Rex G · Shorewood, ILBuilt 1981 · S/N 28-8190302 N8427WKsiezyk Donald G · Wadsworth, OHBuilt 1981 · S/N 28-8290030 N8428BHiggins James · Oxford, NCBuilt 1981 · S/N 28-8190304 N8428HWilson Jessica D · Gallipolis Ferry, WVBuilt 1981 · S/N 28-8190305 N8428SLand O Lakes Flying Club Inc · Bloomfield Hills, MIBuilt 1981 · S/N 28-8190307 N8429XLinville Manor LLC · Reidsville, NCBuilt 1981 · S/N 32R-8113105 N842BJMaster Trade LLC · Detroit, MIBuilt 1977 · S/N 28-7716252 N842CPSeven Wheels Inc · Morristown, TNS/N 3110 N842EFLufthansa Aviation Training USA Inc · Goodyear, AZBuilt 2018 · S/N 2396 N842HJMitchlee LLC · Nashville, TNBuilt 2007 · S/N 2519 N842NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2019 · S/N 4496473 N842SFCopperstate Aviation LLC · Phoenix, AZBuilt 2010 · S/N 2068 N842WTBlue Horizons LLC · West Haven, CTBuilt 2013 · S/N 4025 N842XBarras Lawrence S · San Jose, CABuilt 2007 · S/N 41723 N8430BTrident Aviation LLC · Bedford, NHBuilt 1981 · S/N 32R-8129097 N84326Yang Edward E · Killeen, TXBuilt 1981 · S/N 28-8116313

Back to AD 2008-06-28 R1