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.

N901JWThunderbolt Transport Inc · Memphis, TNBuilt 2022 · S/N 525-1123N901LBNwl Capital Holdings LLC · Black Eagle, MTS/N 560-0218N901LKBhb7 LLC · Vestavia, ALBuilt 1995 · S/N 650-7064N901LMLifeflight Of Maine LLC · Bangor, MEBuilt 1999 · S/N BB-1693N901NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 33226N901PSDavis Aviation Inc DBA · Brandon, MSBuilt 1979 · S/N LA-5N901RHBank Of Utah Trustee · Salt Lake City, UTBuilt 1987 · S/N 650-0130N901SCSc Aviation Inc · Monroe, WIBuilt 2001 · S/N 258561N901SFSingleton Investments LLC · Menlo Park, CABuilt 2004 · S/N BB-1859N901STSky Team Aviation Inc · Wilmington, DEBuilt 1999 · S/N 208B0752N901TMMatanane Roke C · Barrigada, GUBuilt 1977 · S/N LW-227N901TWHobbs Holding LLC · Newark, DEBuilt 1979 · S/N 501-0163N901YBTct Sales LLC · Hernando, MSBuilt 2015 · S/N FL-984N9021V9021 LLC · Sheridan, WYS/N TH-233N9022VBlu Dog Aviation LLC · Greenwich, NYBuilt 1971 · S/N E-276N9023QRegistered aircraftBuilt 1970 · S/N TH-68N9029RArx Aviation LLC · Eustis, FLBuilt 1975 · S/N LW-132N902ABAngel Brothers Enterprises Ltd · Baytown, TXBuilt 2000 · S/N 298N902ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29504N902ATAbet · Freeport, MEBuilt 1991 · S/N E2623N902AUAmafly LLC · Wilmington, DES/N 25N902DBBank Of Utah Trustee · Salt Lake City, UTBuilt 1989 · S/N LJ1202N902DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 62780N902DRBaron Dreams LLC · Inlet Beach, FLS/N TH-1825N902FJ & J III LLC · San Antonio, TXBuilt 1993 · S/N 650-7022N902FEFederal Express Corporation · Memphis, TNBuilt 1986 · S/N 208B0002N902MBB & M Aviation LLC · Bonneau, SCBuilt 1974 · S/N LW-105N902MHMansfield Heliflight Inc · Milton, VTS/N FL-295N902NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 31154N9034VVanderhoof Consulting LLC · Omaha, NEBuilt 1972 · S/N E-368N9036VRobbins Ethan · North Grafton, MABuilt 1970 · S/N E-233N9039VCarper Paul · Conroe, TXBuilt 1973 · S/N E-391N903ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29505N903ARUmb Bank Na Trustee · Salt Lake City, UTBuilt 2002 · S/N 33096N903ATEga Three LLC · Gadsden, TNBuilt 1991 · S/N E2627N903DNDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 32007N903DPKenmore Air Harbor LLC · Kenmore, WABuilt 1999 · S/N 208B0703N903FEFederal Express Corporation · Memphis, TNBuilt 1986 · S/N 208B0003N903GWPro Water Solutions LLC · Henderson, TXBuilt 2008 · S/N 525-0676N903JBigups Aviation 010 LLC · Valley Village, CABuilt 2000 · S/N FL-302N903JDAirventure LLC · Fort Lauderdale, FLS/N 421C0420N903NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2012 · S/N 31153N903TWTwi Air LLC · Picayune, MSS/N BB-1822N903VCrawford Carlos G · Osprey, FLBuilt 1974 · S/N E-562N9042W42w LLC · Jackson, MOBuilt 1974 · S/N E-605N9044VThomas Richard D · Orange City, FLBuilt 1972 · S/N TH-216N9045QJohnson Steven F · Ennis, TXBuilt 1970 · S/N E-231N904ADNorth South Aviation LLC · Belgrade Lakes, MEBuilt 1974 · S/N E-624N904ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29506N904ARUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 33097
Back to AD 2006-16-18 R1