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.

N26RFVuc Inc · Allentown, PABuilt 2010 · S/N FL-722N26RGPlane Fun Inc Tr Trustee · Snellville, GABuilt 1987 · S/N E-2383N26RLJs Aircraft LLC · Eden, NCBuilt 1997 · S/N 525-0207N26TCAcme Nite LLC · Nashville, TNBuilt 2001 · S/N 258521N26TNAj Air LLC · Blackwell, OKS/N 418N26WLTrio Leasing LLC · Highland, MIBuilt 1974 · S/N TH-406N2700BBackcountry Commander LLC · Wray, COBuilt 1955 · S/N 200N2702SMdm Air LLC · Belpre, OHBuilt 2013 · S/N FL-831N270AKAlaska Airlines Inc · Seattle, WABuilt 2017 · S/N 44111N270CLRegistration Pending · Chesterfield, MORegistration pendingBuilt 1990 · S/N 208B0232N270HBemenderfer Todd M · Mishawaka, INBuilt 1947 · S/N D-681N270HSTextron Aviation Inc · Wichita, KSS/N 20800735N270JPLopez Fabio A · Denver, NCS/N 078N270LCMcnutt Air Partners LLC · Corsicana, TXBuilt 1979 · S/N 245N270MFBank Of Utah Trustee · Salt Lake City, UTFirst renewal noticeBuilt 1987 · S/N 509N27117Chalfant William Paxson III · Concord, NCBuilt 1979 · S/N E-1416N2717VBlazek James T · Malta, ILBuilt 1947 · S/N D-93N271EARichardson Cotton Inc · Wilmington, DES/N E-3486N271LVSouthwest Airlines Co · Dallas, TXS/N 29090N271PBClark Mayer Aviation LLC · Cross Roads, TXBuilt 1997 · S/N TH-1840N27205United Airlines Inc · Chicago, ILBuilt 2000 · S/N 30577N27213United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28773N27239United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28951N27246United Airlines Inc · Chicago, ILBuilt 1999 · S/N 28956N272AKAlaska Airlines Inc · Seattle, WABuilt 2017 · S/N 44112N272CTInncal Inc · Stockton, CABuilt 1993 · S/N E-2824N272DNDel Mar College · Corpus Christi, TXBuilt 1978 · S/N 135N273Lone Star Sorties LLC · Dickinson, TXS/N D-1340N2730ASteigenga Nathan L · Suffolk, VAS/N E-1229N2736VHatloy Mark A · Drayton, NDBuilt 1947 · S/N D-116N2737AKnight Farms Inc · Pasco, WABuilt 1969 · S/N E-175N273AKAlaska Airlines Inc · Seatac, WABuilt 2017 · S/N 61554N273EADavis Jonathon W · Charlotte, NCBuilt 2003 · S/N E3497N273HPCalifornia Highway Patrol · Sacramento, CABuilt 2025 · S/N 20800721N27421United Airlines Inc · Chicago, ILBuilt 2008 · S/N 37094N27477United Airlines Inc · Chicago, ILBuilt 2013 · S/N 31647N274AKAlaska Airlines Inc · Seattle, WABuilt 2017 · S/N 61555N274KARgv Sky LLC · Harlingen, TXBuilt 1978 · S/N LW-274N274LECsonka Bela · Hesperia, CABuilt 1962 · S/N 500A-1232-69N274MBAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1977 · S/N 421C0315N274MCLone Eagle Aeronautica LLC · Duncan, OKBuilt 2014 · S/N 208B5104N274PMPlanemasters Ltd · West Chicago, ILFirst renewal noticeBuilt 1998 · S/N 208B0705N274SLHowden Frederick M · Coronado, CAS/N E-2994N2751VGarrett Gregory Todd · Athens, TXBuilt 1947 · S/N D-136N2754VSheldon Paul T · Saint James, MNS/N D-139N275AKAlaska Airlines Inc · Seatac, WABuilt 2017 · S/N 61556N275EASmith Mark K DBA · Hubertus, WIS/N E-3520N275LARts Ventures LLC · San Antonio, TXBuilt 1992 · S/N LJ1275N275LLN275ll LLC · Wilmington, DEBuilt 2007 · S/N FL-566N275TCQualitair LLC Trustee · MichelstadtBuilt 1994 · S/N E2914
Back to AD 2006-16-18 R1