OpenAirDocs.org
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
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.

N2822YThayer Robert N · Portola, CABuilt 1979 · S/N 28-7990471N2823DOloteo Dennis R Jr · San Antonio, TXBuilt 1979 · S/N 28-7990472N2824MDodson International Parts Inc · Rantoul, KSBuilt 2004 · S/N 1144N28251Cae Aviation Academy Phoenix LLC · Mesa, AZBuilt 2013 · S/N 2843729N2825MStanton Jeffrey C · Bracey, VABuilt 1977 · S/N 28-7816313N282BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2016 · S/N 2842418N282BLBlue Line Aviation LLC · Winter Haven, FLBuilt 2023 · S/N 2881674N282CBWhisky Tango LLC · Hendersonville, TNBuilt 2011 · S/N 3782N282CDAurora Partners LLC · Oregon City, ORBuilt 2004 · S/N 1136N282DBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1976 · S/N LW-209N282DJViva LLC · Dover, DEBuilt 2021 · S/N 5066N282DMSkyshoe II LLC · Beverly, MABuilt 2021 · S/N 5035N282DSDickinson Edward L · Midlothian, VABuilt 2003 · S/N 40.282N282DXPiper Aircraft Inc · Vero Beach, FLS/N 28010106N282EEFogprop N282ee LLC · Bolinas, CABuilt 2005 · S/N 1619N282HGCompass Rose 2 LLC · Austin, TXBuilt 1995 · S/N 2842007N282HPSale Reported · OxonSale reportedBuilt 2000 · S/N 2843354N282LSJh Strain & Sons Inc · Tye, TXBuilt 1975 · S/N BB82N282MBMitchell Larry N · Fredericksburg, TXBuilt 2000 · S/N 2843366N282MKAlpe Holding LLC · Van Nuys, CABuilt 2003 · S/N 2842188N282SW3g Classic Aviation Inc · Wilmington, DEBuilt 2009 · S/N 4697420N282THAero Sky Inc · Terrace Park, OHBuilt 2019 · S/N 4748N2830JPagano Nathan J · New Haven, CTBuilt 1979 · S/N 28-7916456N2832MCronin Terrance F · Federal Way, WABuilt 1977 · S/N 28-7816316N2833DScott Glen H · Spring, TXBuilt 1979 · S/N 28-7916451N2833FWeaver Arnold G · Sandusky, MIBuilt 1979 · S/N 28-7916452N2833NLansing Community College · Mason, MIBuilt 1979 · S/N 28-7916453N2833SJohanson Lawrence Gco Trustee · Mckinleyville, CAS/N 28-7916458N2834BSager Arthur · Joseph, ORBuilt 1979 · S/N 28-7990477N2834TCrosswire Networks & Camera Systems Inc · Tampa, FLS/N 28-7990478N2834YAvance Aircraft LLC · Wilmington, DEBuilt 2015 · S/N 4254N2835MWth Aviation Services LLC · Scott City, KSBuilt 1977 · S/N 28-7890271N28360Albert Lea Airport Inc · Albert Lea, MNBuilt 1979 · S/N 28-7916403N28361Propell Air LLC · Deridder, LAS/N 28-7916404N2836GRed Rock Fly LLC · Lewes, DEBuilt 1979 · S/N 28-7916459N2836NGreat Planes Aviation Inc · Rochester, MNBuilt 1979 · S/N 28-7916461N28381Hanscom Aero Club · Hanscom Afb, MABuilt 1979 · S/N 28-7916408N2838DHis Promise Aviation Service Inc · Big Spring, TXBuilt 1979 · S/N 28-7916463N2838FGordon Brennan L · Houston, TXBuilt 1979 · S/N 28-7916464N2839BGartman Henry L Sr · Moberly, MOBuilt 1979 · S/N 28-7990485N283BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2016 · S/N 2842419N283BLWingsleasing LLC · Wichita, KSBuilt 2023 · S/N 2881675N283CAVero Technical Support Inc · Pensacola, FLBuilt 1979 · S/N 44-7995225N283CDChesney Style Inc · Belmont, CABuilt 2015 · S/N 2297N283DDMosier Don · Stanford, KYBuilt 2006 · S/N 1765N283DS3ds Holdings LLC · Martinez, CABuilt 2008 · S/N 40.956N283DXPiper Aircraft Inc · Vero Beach, FLS/N 28010107N283HGCompas Rose 3 LLC · Corinth, TXBuilt 1995 · S/N 2842008N283HPClarke John D Jr · Port Orange, FLBuilt 2000 · S/N 2843360N283JSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 2283
Back to AD 2008-06-28 R1