OpenAirDocs.org
AD 2006-16-18 R1

Registered aircraft · 11,797

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.

N1560Davis Aviation Inc · Brandon, MSS/N BC-09N1560WHigh Performance Aircraft Inc · El Cajon, CABuilt 1997 · S/N E-3097N1560YPacific Integrated Handling · Tacoma, WABuilt 1994 · S/N TH-1717N1561BLamberton Dale F · Brush Prairie, WABuilt 1996 · S/N E-2993N1561GDusky Aviation LLC · Atlanta, GABuilt 1994 · S/N E-2854N1561LRegistered aircraftBuilt 1994 · S/N E-2856N1562FPatton Janet · Denton, TXBuilt 1994 · S/N E-2857N1563EZulu Alpha LLC · Naperville, ILBuilt 1989 · S/N E-2473N1563RNovember One LLC · Trophy Club, TXS/N E-2858N1564DAwy LLC · Bentonville, ARBuilt 1994 · S/N E2905N1564LWhipple Cory · Senatobia, MSBuilt 1976 · S/N TK-6N1565WRoad Kill Aviation Inc · Wilmington, DEBuilt 1972 · S/N E-330N1565XCutting Paul P · Wellington, FLBuilt 1994 · S/N E-2853N1566KShaw David C · Santa Barbara, CABuilt 1989 · S/N TH-1549N1566URegistered aircraftBuilt 1994 · S/N E-2872N1566WPsl Aviation Inc · Atlanta, GABuilt 1994 · S/N TH-1713N1567NAuburn Simflight LLC · Auburn, ALBuilt 1989 · S/N TH-1567N15688Moses & Associates Inc · Gainesville, FLBuilt 1988 · S/N TH-1542N1569ZTran Danh · Moreno Valley, CAS/N D-1107N156GAlliance Air Parts Acquisitions Corp · Oklahoma City, OKBuilt 1975 · S/N LW-156N156LAFresno Beverage Co Inc DBA · Fresno, CABuilt 2018 · S/N FL-1153N156MLAir Miles LLC · River Falls, WIBuilt 1996 · S/N 525-0156N156NSNunya LLC · Costa Mesa, CABuilt 2004 · S/N 258668N156TMWilmington Trust Co Trustee · Wilmington, DEBuilt 2007 · S/N FL-518N156UPUnited Parcel Service Co · Louisville, KYBuilt 2004 · S/N 0845N1570GTurner Michael D · Greenwood, SCBuilt 1989 · S/N E-2512N1570NUp N Down Adventures LLC · Calera, OKBuilt 1994 · S/N TH-1715N15710United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28780N15712United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28783N1577LKoga Corp Inc · Las Vegas, NVS/N E-825N1577WDshannon Products Ltdregistered · Buffalo, MNBuilt 1972 · S/N E-333N1578LBaloian Packing Co Inc · Fresno, CABuilt 1976 · S/N E-826N157BAAirmart Inc · Lexington, KYBuilt 1986 · S/N E-2339N157CKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1995 · S/N UE157N157HJaars Inc · Waxhaw, NCBuilt 2020 · S/N 20800668N157JRSoft Landings LLC · Myrtle Beach, SCBuilt 1991 · S/N TH-1639N157MDDunbar Kevin R · Belmont, NCBuilt 1947 · S/N D-1150N157MHMile Hi Skydivers Inc · Longmont, COS/N LW157N157TFMeyers Aircraft Trading West LLC · Windermere, FLBuilt 1991 · S/N 560-0157N157UPUnited Parcel Service Co · Louisville, KYBuilt 2004 · S/N 0846N1588Indianhead Aviation LLC · Polk City, IABuilt 1978 · S/N E-1290N158BBStubbs J Phillip · Richmond, VABuilt 1975 · S/N TH-592N158BDJ L Aviation LLC · Jonesboro, ARBuilt 1979 · S/N TH-1045N158BHB58 LLC · Granger, INBuilt 1988 · S/N TH-1540N158BJPerfectus Inc · Wilmington, DES/N TH-324N158BMChorman Spraying LLC · Milton, DEBuilt 1981 · S/N TH-1244N158JSMae Aviation LLC · Dover, DEBuilt 2000 · S/N 560-0540N158KPelican Aviation Inc · Gainesville, GABuilt 1980 · S/N TH-1178N158NCIal Corp · Lewes, DEBuilt 1974 · S/N TH-444N158PA2 Laikas LLC · Helena, MTBuilt 1978 · S/N TJ-141
Back to AD 2006-16-18 R1