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.

N669JWKapowsin Air Sports Ltd · Shelton, WABuilt 1968 · S/N 088N669RPFanning William J · Dallas, TXBuilt 1979 · S/N E-1618N66AFSalmon Steven B · Liberty, MOBuilt 1980 · S/N TH1132N66BKJl&Gl Productions Lp · Brentwood, TNFirst renewal noticeBuilt 1982 · S/N 501-0254N66BSValiair Limited Co Trustee · Casper, WYBuilt 1980 · S/N LA-40N66CLLiberty Eagle LLC · Helena, MTBuilt 1980 · S/N 421C1019N66EWTechnical Support Services Inc · Toledo, OHS/N 492N66HBSawtooth Travel Solutions LLC · Twin Falls, IDBuilt 1976 · S/N E-888N66JLLucia Joanne · Agawam, MABuilt 1975 · S/N E-711N66KAMullins Michael · Seaford, DES/N LJ-582N66KDEnalp Investments LLC · Metairie, LABuilt 2003 · S/N E-3505N66LAAviary LLC · Greer, SCBuilt 1987 · S/N E-2394N66LCBusiness Jet Consultants LLC · Derby, KSBuilt 1977 · S/N E-1050N66TGAeroconnection King Air LLC · Miami, FLBuilt 1988 · S/N FA-155N66VAFranco Plastering Inc · Naples, FLBuilt 1983 · S/N 375N66ZBCharter Equipment Leasing LLC · Bellevue, WABuilt 2004 · S/N 258675N67Federal Aviation Administration · Oklahoma City, OKBuilt 1987 · S/N FF-2N670FEFederal Express Corp · Memphis, TNBuilt 1997 · S/N 777N670GCFrauenhoff Frank · Manhattan, NVBuilt 1973 · S/N TH-359N670RAA5 Aviation LLC · Mcallen, TXS/N FA226N670TCBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 208B2374N671AZPima County Board Of Supervisors · Tucson, AZBuilt 2021 · S/N 20800671N671BBe-A36 Inc Owner Trustee · Wilmington, DEBuilt 2001 · S/N E-3409N671FEFederal Express Corp · Memphis, TNBuilt 1997 · S/N 778N671KWKwik Wall 1 LLC · Springfield, ILBuilt 1998 · S/N 5250273N671MMKmwflight LLC · Wilmington, DEBuilt 1984 · S/N 258014N671RAReliable Robotics Corp · Mountain View, CABuilt 1996 · S/N 208B0539N671RRAircraft Fidelity Corp Trustee · Dover, DEBuilt 1993 · S/N 258244N67230Boomerang Air LLC · Cedar Park, TXBuilt 1983 · S/N E-2093N6723YKair Air LLC · Marietta, GABuilt 1982 · S/N LJ-1013N6724TKaufman Melissa R · Franklin, TNBuilt 1984 · S/N E-2163N6724VFlying Bevo LLC · Newark, DEBuilt 1983 · S/N E-2095N6725TQuitman LLC · Spartanburg, SCBuilt 1984 · S/N TH-1423N6725VAdvanced Thermal Systems Inc · West Memphis, ARBuilt 1983 · S/N E-2098N6726DDefini John · Mooresville, NCS/N E-2097N6726SSchaney Michael W · Brookville, OHBuilt 1983 · S/N TH-1390N6727SKt Aero LLC · Charleston, WVBuilt 1983 · S/N E-2100N6728HGuardian Flight LLC · Lewisville, TXBuilt 1984 · S/N BB-1193N6728LHancock Aircraft Sales LLC · Baton Rouge, LAS/N TH-1095N6728VDriftwood Creek Flying Club LLC · Yankton, SDBuilt 1983 · S/N E-2103N67290Price Edward Rollins Vii · Elon, NCBuilt 1980 · S/N TH-1108N6729ZMiddle Tennessee Aircraft Services LLC · Mount Pleasant, TNBuilt 1980 · S/N TH-1109N672AZPima County Board Of Supervisors · Tucson, AZBuilt 2021 · S/N 20800673N672FEFederal Express Corp · Memphis, TNBuilt 1997 · S/N 779N672HD49 Papa Hotel LLC · Sioux Falls, SDBuilt 1980 · S/N LA-33N672JMPeregrine Aviation LLC · Tallahassee, FLBuilt 2002 · S/N 525-0485N672MMTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N FL-540N6732ZAir Pear LLC · Yakima, WAS/N E-1647N67343Gray Reece Allen · Buna, TXBuilt 1980 · S/N E-1649N6734XGood Deal Charlie Inc · Russellville, ARBuilt 1980 · S/N TH-1116
Back to AD 2006-16-18 R1