OpenAirDocs.org
AD 2011-07-13

Registered aircraft · 523

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

N411DPInternational Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N 14517N414LBRegistered aircraftBuilt 1979 · S/N 14524N423ATWillcutt Air Tax LLC · Vicksburg, MIBuilt 1978 · S/N 14391N427G5 Star Farm Management Inc · Linden, CABuilt 1977 · S/N 14294N437JWMj Product Sale Inc · Cape Coral, FLS/N 14075N44MHDrewry James D · Dayton, TXBuilt 1979 · S/N 13308N44NPInternational Air Services Inc Trustee · Carson City, NVBuilt 2000 · S/N 14679N4532WAbernathy Aviation LLC · Morristown, TNBuilt 1976 · S/N 13041N4533WNoco Bluesky LLC · Loveland, COBuilt 1976 · S/N 13042N4536WAlger Michael · Umatilla, FLBuilt 1976 · S/N 13046N4539WWjordan & Co LLC · New Fairfield, CTBuilt 1976 · S/N 13049N4566WBoling Kyle C · Oak Hill, FLBuilt 1976 · S/N 13056N4570WGuffey Jerry D · Lebanon, TNS/N 13060N4571WBernard Scott Sr · Denham Springs, LAS/N 13061N4572WKelton Joel B · May, TXBuilt 1976 · S/N 13062N4575WN4575w LLC · Santa Fe Springs, CABuilt 1976 · S/N 13065N4578WAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 13068N4589WBort Productions Inc · Covina, CABuilt 1976 · S/N 13079N4590WBfi Financial Alliances Limited LLC · Cave Creek, AZBuilt 1977 · S/N 13180N4591WRojas Franklyn N · Ocala, FLBuilt 1976 · S/N 13081N4597WPelupessy Richard A · Roanoke, TXBuilt 1976 · S/N 13087N4603WReichen Kenton Ryan · San Francisco, CAS/N 13093N4604WPlotkin Terry M · Colorado Springs, COS/N 13094N4605WCoyner Philip C · Belpre, OHBuilt 1976 · S/N 13095N4606WCornwell Stephen E · Beaumont, TXBuilt 1976 · S/N 13096N4607WWalmer David H · Tualatin, ORBuilt 1976 · S/N 13097N4608WWalden Brian S · Mount Vernon, OHBuilt 1976 · S/N 13098N4609WBoling Kyle C · Oak Hill, FLS/N 13099N4611WPhillips James E · Mammoth Lakes, CAS/N 13101N4615WPhil 413 Aviation LLC · Laporte, INBuilt 1976 · S/N 13105N4618WCommander Aviation LLC · Seneca, SCBuilt 1976 · S/N 13108N4624WSchultz Michael K · Oak Grove, MOS/N 13155N4625WCowens Marvin W · Plano, TXS/N 13156N4627WDavis Curtis L · Punta Gorda, FLS/N 13158N4634WCannady William E · West Islip, NYBuilt 1977 · S/N 13164N4635WSmith Robert J · Littleton, COS/N 13165N4637WBrimmer Kyron · Encinitas, CABuilt 1977 · S/N 13167N4638WHavens Todd · Airway Heights, WABuilt 1977 · S/N 13168N4639WValiair Lc Trustee · Casper, WYBuilt 1977 · S/N 13169N4640WBerger Adam · Kanab, UTBuilt 1977 · S/N 13170N4642WHash Marshall W · Crumpler, NCS/N 13172N4645WClimb Maintain LLC · Morrisville, MOBuilt 1977 · S/N 13175N4655WAeroflyin Corp · Miramar, FLBuilt 1977 · S/N 13185N4656WGross Bruce A · Salida, COS/N 13186N4658WRehberg Michael C · Albuquerque, NMBuilt 1977 · S/N 13188N4663WMoeller Thomas R · Evergreen, COBuilt 1977 · S/N 13193N4666WTimestone Corp · Calexico, CAS/N 13303N4668WMika Brian David · Andover, MNBuilt 1979 · S/N 13305N4670WSezar Hameed Ed · Woodland Hills, CABuilt 1979 · S/N 13307N4676WZaid LLC · Windermere, FLBuilt 1978 · S/N 13252
Back to AD 2011-07-13