AD 2005-12-13

Registered aircraft · 479

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:2005-12-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:2005-12-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.

N499ATN633at LLC · Punta Gorda, FLS/N 414A0306N499CAHyannis Air Service Inc · Hyannis, MABuilt 1985 · S/N 402C1006N5000UMci Air LLC · Wilmington, DEBuilt 1979 · S/N 414A0318N501CLSalt Aerial Aviation LLC · Hamel, MNS/N 414A0339N505CNLes Amis Air LLC · Dorado, PRBuilt 1978 · S/N 414A0201N509RSHalf Shell Aviation LLC · Highlands Ranch, COBuilt 1978 · S/N 414A0060N50CBHughes Eugene F Jr · Butte, MTBuilt 1979 · S/N 414A0228N50MAGoodhue David H · Vancouver, WABuilt 1979 · S/N 414A0434N510NEAirswiss Inc · Wilmington, DEBuilt 1984 · S/N 402C1001N512KZotec Partners LLC · Carmel, INBuilt 1978 · S/N 414A0054N5134CEzrydr LLC · Huntsville, ALBuilt 1982 · S/N 414A0852N514LPInvader Aviation LLC · Tijeras, NMBuilt 1980 · S/N 414A0507N514NCHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0514N524CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1981 · S/N 402C0522N5293JWestsand Aviation LLC · Allegan, MIBuilt 1982 · S/N 414A0857N52RBHeights Multi Flight Management LLC · Monroeville, NJBuilt 1979 · S/N 414A0302N532EBJeb Air LLC · Waverly, OHBuilt 1980 · S/N 414A0440N533ACEast Tennessee Aviation Services LLC · Harrison, TNBuilt 1978 · S/N 414A0103N533STGentry Air LLC · Orlando, FLBuilt 1978 · S/N 414A0034N535CRScs Assets LLC · Ponce, PRBuilt 1979 · S/N 414A0244N5372CFlc Aviation LLC · Dyersburg, TNBuilt 1978 · S/N 414A0110N53WTRock House LLC · Keizer, ORBuilt 1980 · S/N 414A0533N540NEAirswiss Inc · Wilmington, DEBuilt 1984 · S/N 402C0809N548GAHyannis Air Service Inc · Hyannis, MABuilt 1982 · S/N 402C0653N54JQRegistered aircraftN-number assigned (import), not yet registeredS/N 414A0086N553LPMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 1978 · S/N 414A0092N553SWHeritage Air LLC · Grove, OKBuilt 1981 · S/N 414A0614N555CTN555ct LLC · Largo, FLBuilt 1981 · S/N 414A0822N555WPSherry-Aire LLC · Sidney, MTS/N 414A0074N55LPAir Flight Inc · Fort Lauderdale, FLBuilt 1980 · S/N 402C0401N5680CSea Spray Aviation LLC · New Smyrna Beach, FLBuilt 1978 · S/N 414A0218N5688C5688c LLC · Glendale, AZBuilt 1978 · S/N 414A0221N5690CTailwinds Aircraft Holdings LLC · Harrisburg, NEBuilt 1979 · S/N 414A0222N569JMInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N 414A0425N569PAHerron Aviation Group LLC · Dexter, MIS/N 414A0461N56GKMatan Kai LLC · West Hollywood, CAS/N 414A0847N56TJTrue North Aviation LLC · Leclaire, IABuilt 1981 · S/N 414A0804N575JBForbes Consolidated Inc · New Smyrna Beach, FLS/N 414A0426N575SWHester Thomas F · Santa Barbara, CABuilt 1979 · S/N 414A0268N57PBHyannis Air Service Inc DBA · Hyannis, MABuilt 1980 · S/N 402C0300N5826CBank Of Utah Trustee · Salt Lake City, UTBuilt 1979 · S/N 402C0050N58AWAmplatz Left Aviation LLC · Rapid City, SDS/N 414A0276N58HBjk Aviation LLC · Morgantown, WVBuilt 1979 · S/N 414A0314N596DMAirswiss Inc · Wilmington, DES/N 402C0255N598ASAssociated Auction & Liquidation Co · Clarksburg, TNBuilt 1984 · S/N 414A1003N598DMAirswiss Inc · Wilmington, DEBuilt 1979 · S/N 402C0114N5AMTexas La Flyers LLC · West Monroe, LAFirst renewal noticeBuilt 1979 · S/N 414A0441N5CNLewis Gentry Holdings LLC · Orlando, FLBuilt 1978 · S/N 414A0073N5NMNelson Jeffrey S · Darby, MTBuilt 1978 · S/N 414A0042N600HCCessna 414a LLC · Portland, ORBuilt 1978 · S/N 414A0025
Back to AD 2005-12-13