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.

N36VMTri-Rivers Enterprise · Cameron, MOBuilt 1988 · S/N E-2411N36VPA&J Delivery Inc · Olive Branch, MSS/N E-3584N36VTTurley Ty P · Ramona, CABuilt 1993 · S/N E-2806N36VUThomas Gary F · Mount Shasta, CABuilt 2002 · S/N E-3449N36WEMajor Holdings LLC · Lewes, DEBuilt 1975 · S/N E-728N36WFLongboat Key Aviation LLC · Wooster, OHBuilt 1976 · S/N E-855N36WPMarsh Paul S · Lansing, MIBuilt 1979 · S/N EA-13N36YPVillages Equipment Co · Leesburg, FLBuilt 1987 · S/N E-2358N36YSSlow Roll LLC · Gainesville, FLBuilt 1974 · S/N E-549N36YVN36yv Holdco LLC · Mount Pleasant, SCBuilt 1978 · S/N E-1244N3700MBoeing Co · Berkeley, MOBuilt 1980 · S/N LW-340N3701DN3701d LLC · Wilmington, NCBuilt 1980 · S/N TH-1187N3701ZN3701z LLC · Athens, GABuilt 1980 · S/N E-1748N3703NGreystone Enterprises Inc · Oklahoma City, OKBuilt 1947 · S/N D-909N3704ACousin Sydney Louis Jr · Renton, WABuilt 1970 · S/N E-202N3705NRogers Laurin A · Kennewick, WABuilt 1947 · S/N D-911N3707TFisher Kurt A · San Luis Obispo, CABuilt 1970 · S/N TH-110N37084Bank Of Utah Trustee · Salt Lake City, UTS/N FL482N37091Lee James P · Madisonville, TNBuilt 1980 · S/N E-1761N370BCBcm Majestic Corp · Dallas, TXBuilt 1986 · S/N 23468N370CSReach Air Medical Services LLC · Santa Rosa, CABuilt 1996 · S/N BB-1550N370TPPhmi Aviation LLC · Lewes, DEBuilt 1984 · S/N 650-0059N370UBoard Of Regents Of The University Of Oklahoma · Norman, OKS/N LJ-1428N3711WMccaul Benjamin · San Luis Obispo, CABuilt 1980 · S/N E-1762N3711YAero Venture Lc · Shreveport, LABuilt 1977 · S/N TH-828N3715BBombers And Barons LLC · Haughton, LABuilt 1980 · S/N TH-1200N37172Driscolls Inc · Watsonville, CAS/N FL-472N371BBLake Peipsi LLC · Williamstown, WVBuilt 2000 · S/N E-3355N371DADelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29619N371RATampa Bay Air Charter LLC · Saint Petersburg, FLS/N E-3590N371RMFwd&L 525 LLC · Cataula, GABuilt 2015 · S/N 525-0900N371SBN333bc LLC · Franktown, COS/N 421C1072N3722NSchmidt Lyle W · Los Lunas, NMS/N D-931N3724DArnold Aviation LLC · Lisle, ILS/N E-3624N37252United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30583N37253United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30584N37255United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30610N3725NIvy James H III · Seligman, AZS/N D-934N37263United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31583N37267United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31586N37273United Airlines Inc · Chicago, ILBuilt 2001 · S/N 31591N37274United Airlines Inc · Chicago, ILBuilt 2002 · S/N 31592N37277United Airlines Inc · Chicago, ILBuilt 2002 · S/N 31595N37281United Airlines Inc · Chicago, ILBuilt 2003 · S/N 31599N37287United Airlines Inc · Chicago, ILBuilt 2004 · S/N 31636N37290United Airlines Inc · Chicago, ILBuilt 2004 · S/N 31601N37293Bank Of Utah Trustee · Salt Lake City, UTBuilt 2005 · S/N 33453N37298United Airlines Inc · Chicago, ILBuilt 2005 · S/N 34004N372DADelta Air Lines Inc · Atlanta, GABuilt 1998 · S/N 29620N372JBUltra Property Acquisitions LLC · Edinburg, TXBuilt 1980 · S/N BB-719
Back to AD 2006-16-18 R1