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.

N326SRCharlie Tango Aviation LLC · Miami, FLBuilt 2006 · S/N 1934N326TKClark Shawn B · Fairhope, ALBuilt 2003 · S/N 0716N326VAMaine Instrument Flight · Augusta, MEBuilt 2023 · S/N 9536N3272DTesk Aviation LLC · Steele, MOBuilt 2018 · S/N 4636N3274RBurton Re Holdings LLC · Mustang, OKBuilt 1970 · S/N 28R-31258N327AMSchmidt Steven P · West Springfield, VABuilt 2003 · S/N 0691N327BGGrimsley Aviation LLC · Dallas, TXFirst renewal noticeBuilt 2001 · S/N 4697073N327DTLafferty Jason · Marana, AZBuilt 2004 · S/N 0972N327EEEmpresas Marex Inc · Mayaguez, PRBuilt 2015 · S/N 4170N327HPN327hp LLC · Senoia, GABuilt 2000 · S/N 3257152N327KBStewart-Vahlberg Enterprises LLC · Norman, OKBuilt 2021 · S/N 2732N327MZWdl/Oracle LLC · Tucson, AZBuilt 1998 · S/N 4636160N327NDUniversity Of North Dakota · Grand Forks, NDBuilt 2023 · S/N 2881657N327PLOcf Logistics LLC · Canyon, TXBuilt 1981 · S/N 32R-8229011N327PZMcmage Aviation LLC · Grosse Pointe Park, MIBuilt 2005 · S/N 1507N327RBAerial Applicators Of Missouri LLC · Pollard, ARBuilt 1978 · S/N BB-335N327RHInfineon Properties Of Montana LLC · Helena, MTS/N 0958N327SRBisous Dange LLC · Virginia Beach, VABuilt 2006 · S/N 2122N327TMAir N327tm LLC · Cheyenne, WYBuilt 2022 · S/N 8809N3280RAmson Technology Lc · Des Moines, IABuilt 1969 · S/N 28R-31260N3284REsser Jill · Mason, MIBuilt 1970 · S/N 28R-31261N3287RWright Maurice · Las Vegas, NVBuilt 1970 · S/N 28R-31262N3289QTrident Aircraft Leasing LLC · Easton, MDBuilt 1977 · S/N 28-7716146N328CPX Aviation LLC · Brooksville, FLBuilt 2008 · S/N 3248N328CRDmg Aero LLC · Hickory, NCBuilt 1979 · S/N BB-548N328DKHigh Flight Adventures LLC · Ogden, UTBuilt 2006 · S/N 1749N328DTDelta Tango Aviation LLC · Kingwood, TXBuilt 2020 · S/N 2627N328GArcher Aero LLC · Wilmington, DEBuilt 2019 · S/N 2881115N328HPAlan C Perry LLC · Lake Charles, LABuilt 2000 · S/N 3257166N328JWL & R Cirrus Inc · Portage, PABuilt 2002 · S/N 0225N328MBN328mb LLC · Old Bridge, NJBuilt 2004 · S/N 0867N328RHEchemendia Joel · Kissimmee, FLBuilt 2004 · S/N 1008N328SRStarr Robert J · Burlington, VTBuilt 2007 · S/N 2516N328TJTasker Jerome · Midland, GABuilt 2005 · S/N 41524N3290QCape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1977 · S/N 28-7716147N3293QRegistration Pending · Gainesville, TXRegistration pendingBuilt 1977 · S/N 28-7790447N3293RBrook Jacob C · Broken Arrow, OKBuilt 1969 · S/N 28R-31264N3294RMurray Dennis P · Malta, NYBuilt 1969 · S/N 28R-31265N3299RDavis Charles · Sanford, FLBuilt 1970 · S/N 28R-31270N329DAGo Birds LLC · Newark, DEBuilt 2020 · S/N 2649N329DSWears Peter B · Durham, NCBuilt 2012 · S/N 40.1142N329EDPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 2881991N329HPRight Rudder LLC · Halifax, PABuilt 2000 · S/N 3246166N329KSWings Flights Of Hope Inc · Orchard Park, NYBuilt 2013 · S/N 4636593N329PACoco Aircraft Inc · Merritt Island, FLBuilt 2002 · S/N 2843512N329RDCirrus Design Corp · Duluth, MNS/N 11779N329RMNova Aviators LLC · Great Falls, VABuilt 2011 · S/N 3776N329RWHansen Glenn J · Fairfield, CTBuilt 2007 · S/N 3232073N329SFChampion Air LLC · Louisville, KYBuilt 2008 · S/N 3230N329SRHorn Russell · Woodbridge, CABuilt 2006 · S/N 2073
Back to AD 2008-06-28 R1