AD 2003-26-06

Registered aircraft · 1,564

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:2003-26-06')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2003-26-06')
  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.

N180MFPapa Sierra Holdings LLC · Dover, DEBuilt 2000 · S/N 172N1811FMaster Link Corp · Barceloneta, PRS/N 3430N183EHBristow LLC · Lake Charles, LABuilt 1993 · S/N 2752N183TBBluesky Tb Corp Trustee · Wilmington, DEBuilt 1992 · S/N 3N183WPLj Horizon Ventures LLC · Fort Worth, TXBuilt 2017 · S/N 1213N184SDCounty Of Orange - Air Support · Costa Mesa, CAS/N 4009N1866SAviation Addiction LLC · Fishers, INBuilt 1998 · S/N 1866N1871SGreen Evan R · Calabasas, CABuilt 1998 · S/N 1871N1887SCavort LLC · New York City, NYBuilt 1999 · S/N 1887N1888EChoe Young Kyu · Manhasset, NYBuilt 1999 · S/N 1888N188CDN188cd LLC · Tulsa, OKBuilt 2014 · S/N 1041N188GTI&F LLC · Overland Park, KSBuilt 2001 · S/N 2048N188SJDaxen Logistic LLC · Chino, CABuilt 1993 · S/N 69N1893SSylvester Donald W · Santa Maria, CABuilt 1999 · S/N 1893N1894SCravey Equipment Leasing LLC · Kerrville, TXBuilt 1999 · S/N 1894N189GTKenai Aviation LLC · Akron, OHBuilt 2001 · S/N 2022N189TBPacca Club Inc · Attleboro, MAS/N 891N18SRW4 Air LLC · Willis, TXBuilt 2000 · S/N 161N1903SGriffin Products Inc · Wills Point, TXBuilt 1999 · S/N 1903N1906SMiskovic Dejan · San Jose, CABuilt 1999 · S/N 1906N1909SDennerline Rhett R · Northfield, ILBuilt 1999 · S/N 1909N190AVNghiem Daniel · Westminster, CAS/N 2165N190GTRincon Gabriel · Baton Rouge, LABuilt 2001 · S/N 2023N193BHBlack Mountain Aviation LLC · Boulder City, NVBuilt 1995 · S/N 2894N1967HTbm 700 LLC · Denair, CAS/N 46N197BHNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 1992 · S/N 2666N197TBHardman Andrew D · Prosper, TXS/N 1806N198SAAbel Air LLC · Dorchester, MABuilt 1998 · S/N 1836N19DLDmc Aviation LLC · Jacksonville, FLBuilt 2017 · S/N 1188N19GSDel Rey Dock Company LLC · Key Largo, FLS/N 1637N1ETCalifornia Aerospace LLC · San Francisco, CABuilt 2023 · S/N 1516N1FDSiek Aviation Inc Trustee · Wilmington, DES/N 1614N1J1596 Inc Trustee · Wilmington, DEBuilt 2025 · S/N 1596N1SDPinellas County Sheriffs Office · Clearwater, FLBuilt 2015 · S/N 8024N1TJCowboy Air LLC · Kingfisher, OKS/N 1338N1VCAlmeida Victor · Telluride, COBuilt 2014 · S/N 1022N200STk Aviation LLC · Willow Street, PAS/N 609N203CHCoastal Helicopters Inc · Juneau, AKBuilt 1981 · S/N 1430N204CHCoastal Helicopters · Juneau, AKBuilt 1981 · S/N 2054N204MEArgo Aviation Inc Trustee · Wilmington, DEBuilt 1989 · S/N 909N204YUFly Invest Inc Trustee · Wilmington, DEBuilt 1989 · S/N 910N20AGInternational Air Services Inc Trustee · Carson City, NVBuilt 2000 · S/N 2003N20AJTwigg Brett · Lincoln, ALBuilt 1985 · S/N 475N20CQA-1 Heavy Equipments Corporation · Pembroke Pines, FLS/N 581N20DUHardt Alexander · Tempe, AZBuilt 1985 · S/N 529N20DXBig Sur USA LLC · Boca Raton, FLS/N 613N20DYBpw Aviation LLC · Huntsville, ALS/N 614N20DZWeathers Air LLC · Longwood, FLBuilt 1986 · S/N 615N20ELJrhav LLC · Chassell, MIS/N 622N20ETClear Skies Avionics Inc · Clearwater, FLS/N 621
Back to AD 2003-26-06