OpenAirDocs.org
AD 2006-16-18 R1

Registered aircraft · 11,798

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:2006-16-18-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:2006-16-18-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.

N436FHTextron Aviation Inc · Wichita, KSS/N 525-1436N436RADebon Corp · La Center, WABuilt 1999 · S/N E-3270N4370WHincha Stacie B · Thatcher, AZBuilt 1974 · S/N E-559N4374MThursby William T · Cedar Hill, TXBuilt 1979 · S/N E-1589N4375WTouch N Go Aeroworks LLC · Greenville, SCS/N TH-489N437JPKachemak Bay Flying Service Inc · Huntsville, ALBuilt 2013 · S/N 208B5037N437WFHewitson Enterprises Inc · Avenal, CABuilt 1981 · S/N BB-962N4380WAtaraxia Aircraft Holdings LLC · Greenville, SCBuilt 1974 · S/N TH-448N4380YRichards Aviation LLC · Gadsden, ALS/N FL-280N4384WPacific Media Properties Inc · Santa Ana, CABuilt 1974 · S/N E-536N438BNAntares Aviation LLC · Boca Raton, FLBuilt 1975 · S/N 21045N438CRKilo Alpha 438 LLC · Edgewater, FLBuilt 1978 · S/N BB438N438EL1 Stop Sod & Landscaping Inc · Orlando, FLBuilt 1977 · S/N 421C0274N438FATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N BB-1941N438GMRye Air LLC · Grimes, IABuilt 2000 · S/N E-3353N438GTAtlas Air Inc · White Plains, NYBuilt 2002 · S/N 30766N438JPKalinin Partners LLC · Juneau, AKBuilt 2013 · S/N 208B5038N438SErie Aviation LLC · Salem, ORBuilt 1981 · S/N BB-886N4394WSisson James M · Orlando, FLBuilt 1974 · S/N TH-460N4395WRoberts Aviation LLC · Acworth, GABuilt 2019 · S/N 208B5575N439BSearuggs Quwan E · Houston, TXBuilt 1948 · S/N D-1447N439GTAtlas Air Inc · White Plains, NYBuilt 2002 · S/N 30767N439PWN439pw LLC · Destin, FLBuilt 2000 · S/N LJ-1589N439WAA W Peterson Inc · Warren, MNBuilt 1977 · S/N LW-216N43ADynamic Avlease Inc · Bridgewater, VABuilt 1979 · S/N BC-73N43BEComputer Service Professionals Inc DBA · Wilmington, DEBuilt 1979 · S/N 551-0149N43BGRight Brothers LLC · San Clemente, CABuilt 1994 · S/N FL-117N43BMDodson International Parts Inc · Rantoul, KSBuilt 1981 · S/N 421C1224N43CW42f LLC · Key West, FLBuilt 1990 · S/N 20800175N43DSDs Air LLC · Carrollton, VABuilt 1992 · S/N 650-7016N43HPBarbara Aviation Inc · Middletown, DEBuilt 1977 · S/N TH-885N43JRGlobal Avionics LLC · Downey, CAS/N 258173N43KTTowles Michael D · Corona Del Mar, CABuilt 1993 · S/N E-2808N43LVLight & Variable Lp · Las Vegas, NVS/N E3546N43MMAircraft Holding Solutions LLC · Newark, DEBuilt 2001 · S/N 258543N43NCCitation Encore LLC · Nashville, TNBuilt 2005 · S/N 560-0685N43NWAirvest Partners LLC · New Bern, NCBuilt 2004 · S/N 525-0543N43PCOlsen Air LLC · Hendricks, MNBuilt 1977 · S/N LW-253N43RSWdr Aviation LLC · Midland, TXBuilt 2005 · S/N FL-443N43TPAircraft Holding Solutions LLC Trustee · Newark, DES/N 258628N43VSV1vr LLC · Wilmington, DEBuilt 1985 · S/N S550-0069N43YIsbell Edwin Chad · Spring, TXBuilt 1974 · S/N E-576N440ASAlaska Airlines Inc · Seattle, WABuilt 2013 · S/N 41705N440BLL R Aviation LLC · Plymouth, NCBuilt 1977 · S/N TH-801N440BVBig Sky 205 LLC · Benbrook, TXBuilt 1997 · S/N 5250199N440DL421 Partners LLC · Crown Point, INBuilt 1983 · S/N 421C1401N440KHAircraft 28889 LLC · Lake Mary, FLBuilt 1998 · S/N 28889N440LJByington William · Minden, NVS/N 421C0299N440PCsw Investments LLC · Dover, DES/N LA-119N440SUFutrell Kenneth R · New Smyrna Beach, FLBuilt 1977 · S/N E-1115
Back to AD 2006-16-18 R1