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.

N311JHHuaco Aviation LLC · Waco, TXBuilt 1980 · S/N 421C0814N311MJVacuum Industrial Pollution International Inc · Baton Rouge, LABuilt 1991 · S/N FL-51N311PGKumar Shekar · Greenwood, SCBuilt 1999 · S/N E-3257N311PWQuantic LLC · Morrisville, NCBuilt 1961 · S/N 500A-1106-54N311SRIsr Aviation LLC · Wilmington, DES/N 525-0172N311TPTarvair Eclipse LLC · Burnsville, NCBuilt 1981 · S/N 501-0196N311VPBluegrass Venture Holdings LLC · Louisville, KYBuilt 1999 · S/N 501-0311N3121CUnkefer Edward Lowell · Waynesboro, VAS/N E-2404N3121WAlpha Dog Aviation LLC · Marco Island, FLBuilt 1973 · S/N TH-410N3122RMarrow Henry G · Southern Pines, NCBuilt 1994 · S/N TH-1722N3122UTravel Aviation Inc · Vineyard Haven, MABuilt 1988 · S/N E-2431N3123WSullivan Dan · Kingwood, TXBuilt 1973 · S/N E-500N3124WBaron 24w LLC · Outing, MNBuilt 1973 · S/N TH-411N3127VTyner Steven P Trustee · Lees Summit, MOBuilt 1947 · S/N D-552N3127WWalkcon Holdings LLC · Amarillo, TXBuilt 1988 · S/N E-2433N31291N31291 Aviation LLC · Omro, WIBuilt 1988 · S/N E-2432N312CRMjk Air LLC · Estes Park, COS/N E-23N312CWLb Wings LLC · Midland, MIBuilt 1981 · S/N TH-1204N312DEBest Aircraft Deals LLC · Salt Lake City, UTS/N FA-49N312FUKenmore Crew Leasing Inc Trustee · Bellingham, WABuilt 2001 · S/N 258545N312LCBenair LLC · Bonita Springs, FLS/N E-3560N312MBN312mb LLC · Wilmington, DEBuilt 1981 · S/N BE-113N312RLNyati Worldwide LLC · Sinton, TXBuilt 1997 · S/N FL-164N312STexas Aircraft Parts Brokers LLC · Seguin, TXBuilt 1999 · S/N 258436N3136PCollins Thomas E · Columbus, MSBuilt 1987 · S/N E-2380N3137Avstar Inc · Seattle, WABuilt 1966 · S/N 123N3139WGrace Air LLC · Kalispell, MTBuilt 1973 · S/N E-503N313AWUS Government · Washington, DCS/N FL-391N313CTAlmar Aviation LLC · Greenville, KYBuilt 1979 · S/N BB-461N313DWDurair Inc · Key West, FLBuilt 1996 · S/N LJ-1434N313HAValiair Lc Trustee · Casper, WYBuilt 1993 · S/N FL-96N313MBosco74 LLC · Wilmington, DEBuilt 1963 · S/N 500A-1276-99N313MSEpic Rise LLC · Tulsa, OKS/N 372N313PJRpc Aviation LLC · Fayetteville, ARBuilt 2000 · S/N 302N313SAMccarty David M · Baker City, ORBuilt 1984 · S/N FA-5N313WLPeak Aviation LLC · Royal Oak, MIBuilt 2000 · S/N 525-0366N313XAEastern 737 Asset Holdings LLC · Kansas City, MOBuilt 1991 · S/N 25313N3140VLayton Matthew K · Mesa, AZS/N D-569N31412United Airlines Inc · Chicago, ILBuilt 2002 · S/N 30129N3144YSierra Bravo Zulu LLC · Middletown, DES/N E-2437N3145VClonts Dale · Safford, AZBuilt 1947 · S/N D-575N3145WIfly Aviation LLC · Conway, ARBuilt 1973 · S/N E-505N3146VWittmeyer Jamie J · Wyomissing, PABuilt 1947 · S/N D-756N3147LBrowning Charles H III · Woodbine, MDBuilt 1994 · S/N E-2882N3147VRobb Steven G · Riverside, CABuilt 1947 · S/N D-577N314AWUS Government · Washington, DCBuilt 2004 · S/N FL-387N314LMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N LJ1544N314MRMiller Aviation LLC DBA · Huntington, INBuilt 1976 · S/N LW-184N314PDAmerican Airlines Inc · Fort Worth, TXBuilt 2017 · S/N 31259N314TBMountain Gateway Order Inc · Dripping Springs, TXBuilt 2019 · S/N 208B5532
Back to AD 2006-16-18 R1