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.

N8074TWilliams Evan H · Sebastopol, CABuilt 1979 · S/N 28-8090062 N8074ZTurner Robin L · Irwin, PABuilt 2003 · S/N 1346 N80756Badeaux William C Jr · La Porte, TXBuilt 1979 · S/N 28-8016047 N8075CGuest Stephen J · El Cajon, CABuilt 1979 · S/N 28-8090064 N8075EBlue Sky Flying Club LLC · Granger, IABuilt 1979 · S/N 28-8090065 N8075XBruce Jerry W II · Starkville, MSBuilt 1979 · S/N 28-8016044 N80765Taylor Kyle T · Texas City, TXS/N 28-8016045 N80769Tucker Robert O · Savannah, GABuilt 1979 · S/N 28-8090066 N8077H8077h LLC · Southington, CTBuilt 1979 · S/N 28-8090067 N8077QWakefield Robert · Toccoa, GABuilt 1979 · S/N 28-8090069 N8077RIscovich Mario S · Thousand Oaks, CABuilt 1979 · S/N 28-8090070 N8077WN8077w Inc · Bloomfield Hills, MIBuilt 1979 · S/N 28-8090072 N8077YMagenta Line LLC · Geneva, NYBuilt 1982 · S/N 32R-8213029 N80785Campbell Air LLC · Angola, INBuilt 1979 · S/N 28-8090077 N8078RKhozam George · Murrieta, CABuilt 1979 · S/N 28-8090073 N8078ZL & A Bennett Second Family Lp · Renton, WAS/N 28-8090076 N8079YKaszuba Peter M · Bradenton, FLBuilt 1979 · S/N 28-8016049 N807DAMays Gloriaj · College Station, TXBuilt 1977 · S/N 28-7816227 N807MJNovisun LLC · Warminster, PABuilt 2014 · S/N 4692211 N807SJTurner Strategic Technologies LLC · Norfolk, VABuilt 2025 · S/N 10698 N807SRFrasca Thomas W · Englewood, FLBuilt 2006 · S/N 2067 N807SVBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 2021 · S/N 4496530 N807TFAir Fleet Holdings LLC · Addison, TXBuilt 2024 · S/N 2881700 N807WMGriswold George B III · Cedar Point, NCBuilt 1967 · S/N 28R-30186 N8080AChapel Hill Flying Club Inc DBA · Sanford, NCBuilt 1979 · S/N 28-8016051 N8080CMelo Clayton · Westport, CTS/N 0646 N8081GGonzalez Biorky · Atoka, TNBuilt 1979 · S/N 28-8016053 N8081PCraner Andrew · Richfield, IDBuilt 1979 · S/N 28-8016056 N8081QBormes Aviation Ltd Co · Aberdeen, SDBuilt 1981 · S/N 34-8233075 N8082HWalters Glenn L · Triadelphia, WVBuilt 1979 · S/N 28-8016059 N8082KWood Roger E · Waxhaw, NCBuilt 1979 · S/N 28-8016060 N8083LLoofbourrow Eric A · Livermore, CAS/N 28-8090080 N8084NBlack Tie Limousine LLC · Springville, ALBuilt 1981 · S/N 28-8290090 N80853Candace A Larned Enterprises Inc · Long Beach, CABuilt 1979 · S/N 28-8090082 N8085ALane Community College · Eugene, ORBuilt 1979 · S/N 28-8016065 N8085XGorkes Richard E Jr · Lilburn, GABuilt 1979 · S/N 28-8016068 N8086ECoker Chadwick Daryl · Goldsboro, NCS/N 28-8090083 N8086GMason Aviation Club LLC · Mason, MIBuilt 1979 · S/N 28-8090084 N8086HCloud Catcher Aviation LLC · Great Falls, MTBuilt 1979 · S/N 28-8090085 N8086KClubs 2 LLC · Calabasas, CABuilt 1979 · S/N 28-8090086 N8087EJd Aviation Inc · Muskegon, MIBuilt 1979 · S/N 32R-8029019 N8089CNelco Farms Inc · Fairfield, IAS/N 28-7690102 N8089QFly First LLC · West Memphis, ARBuilt 1981 · S/N 34-8233078 N808CDC M Alvarez Inc · Baton Rouge, LABuilt 2001 · S/N 0114 N808DCWaters John Klas · San Marcos, CABuilt 1976 · S/N 28-7690456 N808EHChristiansen Aviation LLC · Wilmington, DEBuilt 2017 · S/N 2843935 N808ERDurcan David · Kingston, NYBuilt 2003 · S/N 40.319 N808ETJust Plane People LLC · Irvine, CABuilt 2007 · S/N 40.808 N808GLWilliams Tommy J · Southlake, TXBuilt 2007 · S/N 2649 N808GWWahrman Wayne · Calabasas, CABuilt 2005 · S/N 1374

Back to AD 2008-06-28 R1