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.

N355GKAircraft Holding And Leasing LLC · Sarasota, FLBuilt 2019 · S/N 4799 N355MJHaldeman Richard C · Frisco, TXBuilt 2010 · S/N 3550 N355MKNorth Star Aviation Inc · Mankato, MNBuilt 2021 · S/N 2881502 N355MWCotton Aviation Enterprises Inc · Lakeway, TXBuilt 2007 · S/N 2554 N355NEMeyers Air Service LLC · Superior, NEBuilt 2012 · S/N 3902 N355TBravo Busters LLC · Kalispell, MTBuilt 2008 · S/N 3311 N355TGHigh & Fast LLC · Batesville, ARBuilt 2006 · S/N 2158 N355WTSerious Business LLC · Gregory, SDBuilt 2015 · S/N 4167 N3560ECrawford James M · Sparta, MIBuilt 1979 · S/N 28-8016186 N3560VAmdor John E · Harlan, IABuilt 1979 · S/N 28-8090182 N35621Loza Guillermo · Acton, CABuilt 1979 · S/N 32R-8013022 N3562DXin Han Aviation LLC · Atwater, CABuilt 1979 · S/N 44-8095014 N3562GTroy Oakland Pilots Flying Club Inc · Troy, MIBuilt 1979 · S/N 28-8090186 N3562LAndersen Kim · Yucaipa, CABuilt 1980 · S/N 28-8090187 N3564DKar Aviation LLC · Indialantic, FLBuilt 1979 · S/N 32R-8013023 N3564NAbbott Aircraft Sales And Service LLC · Holts Summit, MOS/N 32R-8013024 N3566PDobbin Douglas G · El Paso, TXBuilt 1979 · S/N 32R-8013028 N35671Clemons Preston J · Andover, KSBuilt 1979 · S/N 28-8016204 N35679Mid Valley Flying LLC · Progreso, TXBuilt 1979 · S/N 32R-8029030 N35689Faulkison Brian S · Watkins, COBuilt 1979 · S/N 28-8090193 N3569DFtaviation LLC · Chantilly, VABuilt 1979 · S/N 28-8090168 N3569XPrice Walter R · Beavercreek, OHBuilt 1979 · S/N 32R-8013030 N356ABJupiter Aviation LLC · West Palm Beach, FLBuilt 2026 · S/N 11315 N356ARPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010056 N356BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2024 · S/N 2881805 N356CAWest Road LLC · Whiting, VTS/N 42502 N356CFCoast Flight Training And Management Inc · San Diego, CAS/N 447995282 N356CTCoast Cirrus Training LLC · San Diego, CABuilt 2025 · S/N 11085 N356DADragonfly Aviation LLC · Winder, GABuilt 2004 · S/N 40.356 N356HAHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 44-7995004 N356JPKukuruznik LLC · Weston, MABuilt 2006 · S/N 1604 N356LEFly Pharmd LLC · Valdosta, GABuilt 2007 · S/N 2652 N356MKNorth Star Aviation Inc · Mankato, MNBuilt 2021 · S/N 2881503 N356NDAir Shares LLC · Casper, WYBuilt 2003 · S/N 2842184 N356RKMec2 Aviation LLC · Catonsville, MDBuilt 2012 · S/N 3857 N356TTMercator Aviation LLC · Orlando, FLBuilt 2020 · S/N 4971 N35705Paris Air Inc · Vero Beach, FLBuilt 1979 · S/N 28-8016207 N35718Parmerlee David · Grand Rapids, MIBuilt 1979 · S/N 32R-8013032 N3571CEgan Michael S · El Paso, TXS/N 28-8016209 N3572BPiper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 32R-8013033 N3572DTrade Winds Aviation Holdings LLC · Lewes, DES/N 32R-8029033 N3572MPlane Nonsense Inc · Middletown, DEBuilt 1978 · S/N 28-7816356 N3572XKelsoe Gregory Lyle · Clermont, FLBuilt 1979 · S/N 28-8016213 N35732Minney Andrew · Memphis, TNBuilt 1979 · S/N 28-8016195 N35734Registration Pending · Blairsville, GARegistration pendingBuilt 1979 · S/N 28-8016199 N3574CAtd Pilot Training LLC · Kansas City, MOBuilt 1979 · S/N 28-8016200 N3574JI.F.C. Inc · Wayne, NEBuilt 1979 · S/N 28-8090196 N3574KDes Moines Flying Club LLC · Indianola, IAS/N 28-8090197 N35755Varin Joseph J · Smithfield, RIBuilt 1979 · S/N 28-8090200 N3575AScoval Aviation LLC · Murray, KYBuilt 1979 · S/N 32R-8013034

Back to AD 2008-06-28 R1