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.

N2952YPreston Marty D · South Bend, INBuilt 1979 · S/N 28-7990580 N29535Clouse Tyler Woods · Forest City, IABuilt 1979 · S/N 28-7990448 N29537Garcia John C · Peoria, AZBuilt 1979 · S/N 28-7990449 N2953UClarkson Fredrich A · Oro Valley, AZBuilt 1979 · S/N 28-7990582 N2954NLewman Daniel O Jr · Summit, MSBuilt 1979 · S/N 28-7990586 N2955MRls Rental Co DBA · Joplin, MOBuilt 1977 · S/N 28-7816326 N2956PVann Dudley Carroll · Greenville, NCBuilt 1979 · S/N 28-7916583 N2956RFlightline LLC · Summerville, SCBuilt 1979 · S/N 28-7990588 N2959MHanneman Robert · Claremore, OKBuilt 1977 · S/N 28-7890281 N2959QParis Air Inc · Vero Beach, FLBuilt 1979 · S/N 28-7916585 N2959USmart5 LLC · Kissimmee, FLBuilt 1979 · S/N 28-7916588 N295AKGlick Farms Inc · Minot, NDBuilt 2003 · S/N 0719 N295BCWieler Jacob · Petty, TXS/N 28-7916435 N295CDSale Reported · ZlinSale reportedS/N 1206 N295CEConquest 295 LLC · Indianapolis, INS/N 441-0205 N295DLGottschalk Justin R · El Dorado Hills, CABuilt 2007 · S/N 2335 N295EC295ec LLC · Eau Claire, WIBuilt 2002 · S/N 0197 N295JPSparks Robert · Decatur, ALBuilt 2002 · S/N 40.253 N295MRCarrera Air LLC · Tampa, FLBuilt 2005 · S/N 3257405 N295RNew Orleans Aviation LLC · Slidell, LABuilt 1981 · S/N 34-8133185 N295SKds Aviation LLC · Normal, ILS/N 4636174 N295SDErf Flight Services LLC · Corpus Christi, TXS/N 4295 N295SRCarpenter William R · West Springfield, VABuilt 1994 · S/N 3213089 N2960DRed Baron Rentals LLC · Jacksonville, FLBuilt 1979 · S/N 28-7916590 N2961BHyldburg Aviation · Plymouth, MABuilt 1979 · S/N 28-7916591 N2961WKrauss Solutions LLC · Debary, FLBuilt 1979 · S/N 28-7916594 N2962UFlake Philip · Pearland, TXS/N 28-7916598 N2965WFly On LLC · Boise, IDBuilt 1979 · S/N 28-8090003 N2966YPiper Holdings LLC · Osage Beach, MOFirst renewal noticeBuilt 1979 · S/N 32R-8013003 N2967DCalifornia In Nice Inc · San Jose, CABuilt 1979 · S/N 44-7995321 N2969SJorgensen Richard J · Vail, AZBuilt 1979 · S/N 28-8090013 N296CBCalifornia Baptist University · Riverside, CABuilt 2018 · S/N 2881008 N296HPInnova Air LLC · Encinitas, CABuilt 1996 · S/N 3246059 N296MAHot Wings Aviation LLC · Fishers, INBuilt 2026 · S/N 28020266 N296MPMaskair LLC · Mount Pleasant, SCBuilt 2015 · S/N 4252 N296PCCarlyle Air LLC · Morristown, TNBuilt 2008 · S/N 4692008 N296RSFloridian Aerospace LLC · Ormond Beach, FLBuilt 2024 · S/N 10283 N296SRBayland Air LLC · Severna Park, MDBuilt 2006 · S/N 2040 N296ST3 Chiefs Aviation LLC · Essex Fells, NJBuilt 2007 · S/N 4697296 N296TSUbiquitair LLC · San Antonio, TXBuilt 2024 · S/N 10047 N2971VSorensen John · Cape May Ch, NJS/N 28-8016001 N2972CHoosier Aviation LLC · Terre Haute, INBuilt 1979 · S/N 28-8016003 N2972YHopkins Larry G · Malabar, FLS/N 28-8016006 N2973KCrown Heights Footcare · Brooklyn, NYS/N 28-8016007 N2973UMobug LLC · Montgomery, TXBuilt 1979 · S/N 28-8016009 N2973WWarrior Aircraft Corp · Sturgis, MIS/N 28-8016010 N2973XJones Jeffrey S · Roseburg, ORBuilt 1979 · S/N 28-8016011 N2973YValiair Limited Co Trustee · Casper, WYBuilt 1979 · S/N 28-8016012 N2974B4m Aircraft Services LLC · Santa Rosa Beach, FLBuilt 1979 · S/N 28-8090020 N2974NDes Moines Flying Club LLC · Indianola, IABuilt 1979 · S/N 28-8090022

Back to AD 2008-06-28 R1