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.

N2974TTiger Services Inc · Lawrenceville, GABuilt 1979 · S/N 28-8090024N297CLivestock Health Products-Texas Inc · Dalhart, TXBuilt 2004 · S/N 4636359N297CBCalifornia Baptist University · Riverside, CAS/N 2881917N297CDDutton James Alen · Double Oak, TXBuilt 2002 · S/N 1232N297HPCherokee Investments LLC · Monroe, VABuilt 1997 · S/N 3246081N297MAFlaps 30 Gear Down LLC · Laguna Niguel, CABuilt 1997 · S/N 3246062N297MGGeorgia Aviation Authority · Eastman, GABuilt 2017 · S/N 2843863N297PMCentral City Aviation LLC · Carrington, NDBuilt 1997 · S/N 4636101N297TPCates Julia · Florence, SCS/N 1134N29820Wtc Aviation LLC · Shreveport, LABuilt 2018 · S/N 4617N298ATAltura Holdings LLC · New Albany, MSBuilt 1998 · S/N 3257069N298CDInternational Air Services Inc Trustee · Carson City, NVBuilt 2002 · S/N 1175N298CSCirrus Sr22 Somex Inc Trustee · Wilmington, DEBuilt 2005 · S/N 1408N298DSFrondorf James · Cincinnati, OHS/N 40.898N298HPPendergrass Inc · Demopolis, ALBuilt 1998 · S/N 3246110N298MGGeorgia Aviation Authority · Eastman, GABuilt 2017 · S/N 2843864N298NDNational Training 1 LLC · Wilmington, DEBuilt 2001 · S/N 4496085N298PAir-Spacers Inc · Santa Monica, CAFirst renewal noticeBuilt 2002 · S/N 40.242N298SHHeising Sean Allen · Billings, MTBuilt 1993 · S/N 3213064N299ATFlyafrica Aviation LLC · Stormville, NYBuilt 2015 · S/N 2292N299CDLinmac LLC · Miami, FLBuilt 2002 · S/N 1267N299DASybesma Justin T Md · Benton Harbor, MIBuilt 2020 · S/N 40.1229N299FCFeather Flight Aviation Inc · Warwick, NYBuilt 1999 · S/N 3246149N299HPAir King Transports LLC · Helena, ALBuilt 1999 · S/N 3246136N299JPSmith Cindy · Eagle, IDBuilt 2003 · S/N 40.329N299JWRas Aviation LLC · Elyria, OHBuilt 2004 · S/N 1034N299MAMcmg Air LLC · Lufkin, TXBuilt 2007 · S/N 4697294N299MPHessjet LLC · Mc Donald, TNBuilt 2005 · S/N 1396N299MRPlane Viewing LLC · Colbert, WABuilt 2003 · S/N 0753N299NDNational Training 1 LLC · Wilmington, DEBuilt 2001 · S/N 4496077N299PAH & H Aviation LLC · Dunn, NCBuilt 1999 · S/N 2843230N299PMFailte Aire LLC · S Abingtn Twp, PAS/N 0306N299RBKing Air Partners LLC · Howe, OKBuilt 1977 · S/N BB-296N299SRCharleston Executive Aviation LLC · Johns Island, SCBuilt 2007 · S/N 1886N29AMSkywave Aviation Partners LLC · Moultrie, GABuilt 1981 · S/N 32R-8113057N29AVForge Aviation Fleet LLC · Fort Lauderdale, FLBuilt 2025 · S/N 10942N29BP29 Bp LLC · Goshen, NYBuilt 2018 · S/N 4699N29EFFour Forces Aviation LLC · Princeton, NJBuilt 2022 · S/N 8763N29FBRegistered aircraftS/N 32-46051N29HCInternational Air Services Inc Trustee · Carson City, NVS/N 3449073N29HHPalmetto Aviation LLC · Annapolis, MDBuilt 2006 · S/N 41580N29KETj Air Holdings Inc Trustee · Wilmington, DEBuilt 2004 · S/N 4636352N29KGCalvin M Holdings LLC · Dania, FLBuilt 2014 · S/N 4148N29MBluesky Geospatial Ltd · North Adams, MABuilt 1973 · S/N LW88N29PGGroves Morton Dan Patrick · Menlo Park, CABuilt 2003 · S/N 40.341N29SDRegistered aircraftBuilt 1968 · S/N 28R-30583N29TEBessarab Alex · Portland, ORBuilt 1979 · S/N 28-7916397N29UAN29ny LLC · Eatontown, NJBuilt 2005 · S/N 1282N29WHSr-22 Partners LLC · Danville, CABuilt 2004 · S/N 0974N29YACirrus Sr22 1353 Inc Trustee · Wilmington, DES/N 1353
Back to AD 2008-06-28 R1