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.

N372MCPmc Capair LLC · Philadelphia, PABuilt 2022 · S/N FL-1299N3730BDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30538N3731NBerka George · Waterbury, CTBuilt 1947 · S/N D-940N3731TDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30775N3732JDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30380N3733NHorning Richard H · Galion, OHBuilt 1947 · S/N D-943N3733ZDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30539N3734BDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30776N37350Price Brenda · Poplar Bluff, MOBuilt 1980 · S/N E-1768N3735DDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30381N3735TGarner Brian J · Bluffdale, UTBuilt 1980 · S/N E-1764N3736CDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30540N3736DRodriguez Alberto R · San Juan, PRBuilt 1980 · S/N E-1766N3737CDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30799N3737KCavanaugh Kirk M Trustee · Homer Glen, ILBuilt 1982 · S/N E-2019N3738BDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30382N3738NPlane Fun Inc Tr Trustee · Snellville, GABuilt 1947 · S/N D-948N3738RHumphries Scott A · Houston, TXBuilt 1980 · S/N E-1771N3738ZAma LLC · Port Orange, FLS/N E-1772N3739BClipper Air LLC · Cresson, TXBuilt 1980 · S/N TH-1198N3739PDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30541N373AFSe Aero II LLC · Atoka, OKBuilt 1999 · S/N 525-0308N373DADelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29621N373JXJetonex LLC · Sunny Isles Beach, FLS/N 33735N373RRM10 LLC · Rolling Meadows, ILBuilt 1997 · S/N 259N373SUTextron Aviation Inc · Wichita, KSS/N FL-1373N37404Bear Giant LLC · Eden Prairie, MNBuilt 1977 · S/N 421C0339N37408United Airlines Inc · Chicago, ILBuilt 2001 · S/N 30125N37409United Airlines Inc · Chicago, ILBuilt 2001 · S/N 30126N3740CDelta Air Lines Inc · Atlanta, GABuilt 2000 · S/N 30800N3740NCrimmins Christopher E · Franklin, TNBuilt 1947 · S/N D-956N37413United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31664N37417Registered aircraftS/N 421C0344N37419United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31666N3741BCherokee Trail Aviation LLC · Tontitown, ARBuilt 1980 · S/N E-1722N3741COmr Investments LLC · Dawson, GABuilt 1980 · S/N E-1757N3741NBruzzone Daniel E · Rllng Hls Est, CABuilt 1947 · S/N D-959N3741SDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30487N37420United Airlines Inc · Chicago, ILBuilt 2008 · S/N 33457N37422United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31620N37424Flight Development LLC · Wichita, KSS/N 421C0658N37427United Airlines Inc · Chicago, ILBuilt 2008 · S/N 37097N3742B22835 Holdings LLC · Wilmington, DEBuilt 2018 · S/N FL-1145N3742CDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30835N3742NAsp Kenneth J · Thief River Falls, MNBuilt 1947 · S/N D-960N37434United Airlines Inc · Chicago, ILBuilt 2009 · S/N 33528N37437United Airlines Inc · Chicago, ILBuilt 2009 · S/N 33532N3743HDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30836N3744FDelta Air Lines Inc · Atlanta, GABuilt 2001 · S/N 30837N37456United Airlines Inc · Chicago, ILBuilt 2012 · S/N 37205
Back to AD 2006-16-18 R1