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.

N728VAero Research LLC · Kalispell, MTBuilt 1975 · S/N E-641N7293RAir New England LLC · Portsmouth, NHBuilt 1975 · S/N TH-590N7299RLindeman Russell L DBA · D Hanis, TXBuilt 1975 · S/N E-648N729AKDavis Aviation Inc DBA · Brandon, MSBuilt 1988 · S/N FA106N729ATN88ca III LLC · Stuart, FLBuilt 1999 · S/N 258402N729CAAc Spe 6 LLC · Orlando, FLBuilt 1991 · S/N 25068N729CKConair USA Co · Dover, DEBuilt 1982 · S/N 22982N729CWWright Matthew J · Bowling Green, OHBuilt 1987 · S/N E-2390N729FDFederal Express Corp · Memphis, TNBuilt 1992 · S/N 657N729FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0474N729GTBig Sky Aviation LLC · Bozeman, MTBuilt 1996 · S/N FL-143N729TATextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 208B5939N729WREiron Nadav Trustee · Portola Valley, CABuilt 2000 · S/N 525-0398N72ACAlliance Service Inc · Lexington, KYBuilt 2007 · S/N 525-0643N72AVAvalair Aircraft Management LLC · Brookshire, TXBuilt 1977 · S/N E-1093N72BRPrestige Air Travel · Middletown, DES/N E-2065N72BTPhenom Partners LLC · Wilmington, DEBuilt 1999 · S/N 525-0306N72FCAlliance Aviation Group LLC · Wilmington, DEBuilt 2001 · S/N 258519N72FERegistered aircraftBuilt 2002 · S/N FL-344N72GLPalm Development Partners LLC · Lexington, TNS/N LJ1261N72GPWade Joseph R · Mindoro, WIBuilt 1968 · S/N E-59N72HAMcn Aviation Partners LLC · Charlestown, INBuilt 2000 · S/N 258503N72HTSan LLC · Knoxville, TNBuilt 1984 · S/N BB-1153N72JWTitle Financial Group LLC · Blackfoot, IDBuilt 2000 · S/N 525-0406N72KAKenmore Air Harbor LLC · Kenmore, WABuilt 1992 · S/N 208B0326N72KKBluebird Holdings LLC · Morris, MNFirst renewal noticeS/N E-3521N72MBSwenson Chuck · Stanchfield, MNBuilt 1977 · S/N E-1010N72MDBenanti Philip E · Melville, NYFirst renewal noticeBuilt 1977 · S/N E-1149N72MFSilverdart Inc · Wilmington, DEBuilt 1984 · S/N E-2191N72NGNorthrop Grumman Systems Corp · El Segundo, CABuilt 2016 · S/N FL-1047N72PTInverted Holdings LLC · Newnan, GAFirst renewal noticeBuilt 1973 · S/N TH-381N72PVBowman Theodore R · Santa Ynez, CABuilt 1988 · S/N E-2452N72RGBushbird LLC · Sioux Falls, SDBuilt 2019 · S/N 20800656N72RWKing Air N72rw LLC · Irvine, CABuilt 2016 · S/N FL-1055N72TGSouthland Entertainment Inc · Wrightsville Beach, NCBuilt 1990 · S/N LJ-1252N72VJYingling Consultation LLC · Wilmington, DEBuilt 1980 · S/N 501-0149N72WPRegistered aircraftBuilt 1985 · S/N E-2288N72WTRoberts Gregory · Bethesda, MDBuilt 1984 · S/N E-2165N73Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-8N7302RBurns James P DBA · Plainview, ILBuilt 1974 · S/N TH-472N730DFDunn Diehl Farms LLC · Wimauma, FLBuilt 1993 · S/N 067N730FDFederal Express Corp · Memphis, TNBuilt 1992 · S/N 659N730FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0477N730GYG&Y Airline LLC · Longview, TXBuilt 2019 · S/N 525-1016N730HMIsr Aviation LLC · Wilmington, DEBuilt 1999 · S/N BB-1648N7315RMitchell Michael · Prattville, ALBuilt 1974 · S/N E-558N7318ABaron Associates LLC · Norfolk, VAS/N TH-2072N731DCSunshine Aviation LLC · Jackson, TNBuilt 2019 · S/N 525-1039N731EMAuer William W · Saint Petersburg, FLBuilt 1988 · S/N E-2446N731FDFederal Express Corp · Memphis, TNBuilt 1993 · S/N 709
Back to AD 2006-16-18 R1