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.

N39PMBank Of Utah Trustee · Salt Lake City, UTS/N 34-8233049N39TVecchiarelli Timothy J · Somers, CTS/N 28-7716267N39THBrandell LLC · Wilmington, DEBuilt 2001 · S/N 3257225N39WVLojac Air LLC · Yukon, OKBuilt 2008 · S/N 3196N3CFFlying Success LLC · Apex, NCBuilt 2025 · S/N 10580N3CVMc Investment Services Inc · Inlet Beach, FLBuilt 2009 · S/N 4697409N3DNNodorft Daniel F · Orlando, FLBuilt 1983 · S/N 28-8390043N3HBSunset Aviation LLC · Port Angeles, WABuilt 1979 · S/N BB-453N3HYWyco Aviation LLC · Kalispell, MTBuilt 2001 · S/N 3257252N3LSConcept Management Company LLC · Spartanburg, SCBuilt 1977 · S/N LW-245N3LWKyllar LLC · Madison, WIBuilt 2002 · S/N 0347N3TZCasey Edmond L Trustee · Los Angeles, CABuilt 1968 · S/N 28R-30490N3YHMarsaudon David · Friday Harbor, WABuilt 2002 · S/N 0239N3ZGIsbell Tony A · Rainbow City, ALS/N 1572N3ZLN3zl LLC · Ocala, FLBuilt 2005 · S/N 1536N3ZZMidwest Corporate Air Inc · Bellefontaine, OHBuilt 2007 · S/N 40.823N40005Williams Brian · Rhinebeck, NYBuilt 1977 · S/N 28-7716312N40006Kotwal Pramod · Bedford, MABuilt 1977 · S/N 28-7716314N40008Birkland Mitchell L · Lake Jackson, TXBuilt 1977 · S/N 28-7716317N40015Wings Flying Club Inc · Sheperdsville, KYBuilt 1977 · S/N 28-7716319N40016Miller Aircraft Services Inc · Crookston, MNBuilt 1977 · S/N 28-7716320N40017Biro Of Chicago Inc · Chicago, ILBuilt 1977 · S/N 28-7716321N40019Registered aircraftBuilt 1977 · S/N 28-7716322N40021Zieber Josh · Leesville, LAS/N 28-7716323N40023Stice Garrett · Summit, ARBuilt 1977 · S/N 28-7816002N40037Pars Avn Corp · Wilmington, DES/N 28-7816003N40042Volar Corp · El Cajon, CABuilt 1977 · S/N 28-7816004N40045Lawson William · Somerset, WIBuilt 1977 · S/N 28-7816006N40057Hovnanyan Ari · Van Nuys, CABuilt 1977 · S/N 28-7716313N40058Johnson Cassandra · Temecula, CABuilt 1977 · S/N 28-7816007N40060Marshall Loraine · Independence, KYBuilt 1977 · S/N 28-7816009N40062Kiwi Air Inc · Sausalito, CAS/N 28-7890003N40069Brown Willard Jr · Far Hills, NJS/N 28-7890170N40070Penski Christopher E · Ocala, FLBuilt 1977 · S/N 28-7816012N400ARArh Aviation LLC · Gainesville, FLBuilt 2010 · S/N 3684N400AWThomson Roy · New Castle, COS/N 41025N400BATulip Tree Hill LLC · Bloomington, INBuilt 2008 · S/N 411054N400BUAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2008 · S/N 411047N400CBSamper Aviation LLC · Easton, PABuilt 1969 · S/N 28R-31123N400CCRegistered aircraftBuilt 2007 · S/N 40.861N400DRKestrel Merlin LLC · Lambertville, MIBuilt 2007 · S/N 41792N400EAMdts Corp · Eden Prairie, MNBuilt 2008 · S/N 411036N400FALifeline LLC · Jacksonville, ORBuilt 2008 · S/N 411103N400FNPb Management LLC · Montgomery, TXBuilt 2008 · S/N 411011N400GFLively Joshua · Montague, MABuilt 1985 · S/N 32R-8613002N400HFEastern Stearman Inc Trustee · Leesburg, VABuilt 2006 · S/N 41577N400JRAirspeed Investments LLC · Springfield, TNBuilt 1982 · S/N 28-8316007N400JVAero Beach Club LLC · North Palm Beach, FLBuilt 2020 · S/N 4958N400KCGoldsmith Aero Holdings LLC · Pensacola, FLBuilt 2006 · S/N 41616N400KGDg Aviation LLC · Mansfield, TXBuilt 2008 · S/N 411072
Back to AD 2008-06-28 R1