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.

N18763Registration Pending · San Jose, CARegistration pendingBuilt 1977 · S/N E-1158N1877LShrauner Reid E · Elkhart, KSBuilt 1976 · S/N E-857N187ALAlm Holdings Delaware 2 LLC · Wilmington, DES/N LJ842N187CSNorris Marvin D · Georgetown, TXBuilt 1999 · S/N E-3232N187GCZuni LLC · Kirkland, WABuilt 2010 · S/N 208B2213N187MCAe Aircraft LLC · Longview, TXBuilt 1998 · S/N 525-0276N187MRJcs Air LLC · Auburn, ALS/N BB-873N187VDepartment Of Homeland Security · Washington, DCBuilt 2009 · S/N FL-679N1886W86 Whiskey Corporation · Vineland, NJBuilt 1973 · S/N E-441N1889WSabre 65 LLC · Helena, MTBuilt 1973 · S/N TH-341N188ALAlm Holdings Delaware 3 LLC · Wilmington, DES/N BB-111N188GCZuni LLC · Kirkland, WABuilt 2010 · S/N 208B2210N188GWBrown Die Casting & Manufacturing Inc · Royse City, TXBuilt 1979 · S/N 421C0613N188KAErostar LLC · Wilmington, NCBuilt 2024 · S/N FL-1333N188LLTriple Aviation LLC · San Leon, TXBuilt 1981 · S/N BE-119N188RCHodgskies Holdings LLC · Choteau, MTBuilt 1984 · S/N E-2189N188SBHigh Flyers LLC · Hobbs, NMBuilt 2015 · S/N 525-0879N1891WSchwartz Eric · Timnath, COBuilt 1973 · S/N E-440N1893LHarlan Blake · Trinity Center, CABuilt 1976 · S/N E-863N1895LPalm Group LLC · Metairie, LABuilt 1977 · S/N TH-894N189APRegistered aircraftBuilt 1975 · S/N BB-59N189AROverstreet Investments Inc · Boonville, MOBuilt 2021 · S/N 208B5650N189GCCortez Fisher LLC · Kirkland, WABuilt 1981 · S/N 772N189MDCae III Ltd · Wilmington, DEBuilt 2014 · S/N FL-931N189WTWp Aviation LLC · Grove City, OHBuilt 2002 · S/N 560-0613N18AFN220pb LLC · Mesa, AZBuilt 1994 · S/N BB-1497N18CCTamcar Aviation LLC · Kennewick, WAS/N NA0222N18CMEdgewater Aviation LLC · Guntersville, ALFirst renewal noticeBuilt 1984 · S/N LA-219N18CVE4 Management LLC · Boyd, TXBuilt 1992 · S/N 5600159N18DRBurns Donald N DBA · Watkinsville, GABuilt 1978 · S/N E1228N18EVE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1983 · S/N 077N18GBRm Equipment LLC · Seattle, WABuilt 1995 · S/N 650-7048N18GUKnoc LLC · Hinsdale, ILBuilt 2001 · S/N 258522N18HCN4bzjp LLC · Asheville, NCBuilt 1981 · S/N 501-0223N18HMYoung Craig · Ada, MIBuilt 1975 · S/N TH-651N18KATreetoppers II LLC · Newark, DEBuilt 1978 · S/N BB-360N18KFNelco Inc · Blanchard, OKBuilt 1978 · S/N E-1251N18LLPiping Technology Consultants Inc · Monee, ILBuilt 1978 · S/N E-1332N18MJFleeman Julie · Laguna Niguel, CABuilt 1978 · S/N E-1250N18MYWorld Aircraft Leasing Inc · Wilmington, DEFirst renewal noticeS/N LJ562N18NMRrcm Air LLC · Hialeah Gardens, FLBuilt 2016 · S/N 208B5303N18NRWonderful Pistachios & Almonds LLC · Lost Hills, CABuilt 2018 · S/N 20800610N18SFD&D Maintenance LLC · Etna Green, INBuilt 1985 · S/N LA236N18TCAviotti Inc · Henderson, NVBuilt 1978 · S/N 421C0503N18VGBullet Aviation LLC · Missoula, MTBuilt 1999 · S/N E-3255N18VRVentura Air LLC · Wilmington, DEBuilt 1996 · S/N TH-1771N18WWFourth Sister LLC · Wilmington, DEBuilt 1994 · S/N E-2860N18XBecker James · Crystal Lake, ILBuilt 1978 · S/N E-1353N18ZKHappy Cat Cay LLC · Coral Gables, FLBuilt 2019 · S/N 208B5513N1900ABank Of Utah Trustee · Salt Lake City, UTS/N 26
Back to AD 2006-16-18 R1