OpenAirDocs.org
AD 2006-16-18 R1

Registered aircraft · 11,797

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.

N999SKWkqm LLC · Wilmington, DEBuilt 1997 · S/N TH-1815N999TBHoneywell Aerospace US LLC · Phoenix, AZBuilt 2000 · S/N BB-1738N999VBJet Air Inc · Galesburg, ILBuilt 1995 · S/N BB-1506N999WLLatshaw Training Group Inc · Vero Beach, FLS/N 421C0320N999WSCloud Based Services LLC · Warner Robins, GABuilt 1981 · S/N 501-0186N999WVWright Air Service Inc · Fairbanks, AKBuilt 2009 · S/N 208B2082N999ZGCfc LLC · Bloomington, INBuilt 2012 · S/N FL-814N99ACRejo Inc · Wilmington, DEBuilt 1974 · S/N LW-120N99BDOcm Aviation LLC · Garner, NCBuilt 1977 · S/N E-1147N99BRAircorps Aviation LLC · Bemidji, MNBuilt 1980 · S/N E-1688N99CJBryan Air LLC · Poway, CABuilt 1999 · S/N 525-0333N99CKCypress Aircraft Sales LLC · Clermont, FLFirst renewal noticeBuilt 1980 · S/N 501-0153N99DAAuburn Aero Holdings LLC · Auburn, INBuilt 1975 · S/N TH-619N99GPHousley Communications Inc · San Angelo, TXBuilt 1987 · S/N LJ-1155N99JGrubbs Terry · Gregory, SDBuilt 1947 · S/N D-165N99LFLake Air LLC · Jonesboro, ARBuilt 1981 · S/N TH-1261N99NPColonial Export Inc · Pompton Plains, NJBuilt 1976 · S/N E-809N99QR W Zollinger Consulting Engineers Inc · Moon Township, PABuilt 1947 · S/N D-277N99RATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2021 · S/N FL-1278N99RFEcho Bravo Aviation LLC · Nashville, TNBuilt 1974 · S/N TH-463N99RKNorth Shore Flying Club · Libertyville, ILBuilt 1992 · S/N TH-1649N99SBBonanza Service Ltd Co · Bethany, OKBuilt 1971 · S/N E-281N99TDAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1991 · S/N TH1641N99WPMarco Investments · Ripley, MSBuilt 1978 · S/N TH-958N99WTSudick Daniel · Dadeville, ALBuilt 2000 · S/N TH-1959N99YSAirspeed And Money LLC · Coweta, OKBuilt 1968 · S/N E-82N9ALoughrey Gary T · Queensbury, NYBuilt 1947 · S/N D-523N9AYProclaim Aviation Ministries · Worthington, MNBuilt 1980 · S/N 421C0844N9BNBrookfield Bonanza Corp · Menomonee Falls, WIBuilt 1982 · S/N E-2046N9GAN9ga Leasing LLC · Ponca City, OKBuilt 2000 · S/N BB-1719N9GTRedemption Inc · Kodiak, AKBuilt 1989 · S/N 20800153N9JFMontgomery David N · Knoxville, TNBuilt 1972 · S/N E-362N9KMRefrigeration Supplies Distributor · Lake Forest, CABuilt 2023 · S/N 525-1149N9LTRegistered aircraftBuilt 2001 · S/N TH-1989N9LYCaravan Adventures LLC · Helena, MTBuilt 2022 · S/N 208B5723N9MPYen Albert S · Hermosa Beach, CABuilt 2002 · S/N E-3471N9NXTalkeetna Aero Services Inc · Anchorage, AKS/N 20800129N9RDFlying Colors Airparts Inc · Leesburg, FLS/N 220N9RZChapman Inc · Sherman, TXS/N 421C0236N9TCSouthwestern Aviation LLC · Pueblo, COBuilt 1976 · S/N E-923N9TEAlliance Aviation Group LLC · Wilmington, DEBuilt 1991 · S/N 204N9UZCf Aviation Trust LLC Trustee · Wilmington, DEBuilt 1974 · S/N LJ641N9VCArocosta LLC · Coral Gables, FLBuilt 1978 · S/N LJ-763N9VDFruguglietti Joseph Matthew · Burney, CABuilt 1947 · S/N D-467N9WLWell Lived Mt LLC · Kalispell, MTBuilt 2008 · S/N FL-613N9WRJ P W Investments Inc · Frederick, MDBuilt 1981 · S/N BB-913N9YTYarberry Timothy C · Anderson, INBuilt 1997 · S/N E-3125
Back to AD 2006-16-18 R1