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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N499ATN633at LLC · Punta Gorda, FLN499CAHyannis Air Service Inc · Hyannis, MAN5000UMci Air LLC · Wilmington, DEN501CLSalt Aerial Aviation LLC · Hamel, MNN505CNLes Amis Air LLC · Dorado, PRN509RSHalf Shell Aviation LLC · Highlands Ranch, CON50CBHughes Eugene F Jr · Butte, MTN50MAGoodhue David H · Vancouver, WAN510NEAirswiss Inc · Wilmington, DEN512KZotec Partners LLC · Carmel, INN5134CEzrydr LLC · Huntsville, ALN514LPInvader Aviation LLC · Tijeras, NMN514NCHyannis Air Service Inc · Hyannis, MAN524CAHyannis Air Service Inc DBA · Hyannis, MAN5293JWestsand Aviation LLC · Allegan, MIN52RBHeights Multi Flight Management LLC · Monroeville, NJN532EBJeb Air LLC · Waverly, OHN533ACEast Tennessee Aviation Services LLC · Harrison, TNN533STGentry Air LLC · Orlando, FLN535CRScs Assets LLC · Ponce, PRN5372CFlc Aviation LLC · Dyersburg, TNN53WTRock House LLC · Keizer, ORN540NEAirswiss Inc · Wilmington, DEN548GAHyannis Air Service Inc · Hyannis, MAN54JQRegistered aircraftN-number assigned (import), not yet registeredN553LPMontana Aircraft Trust Inc Trustee · Bozeman, MTN553SWHeritage Air LLC · Grove, OKN555CTN555ct LLC · Largo, FLN555WPSherry-Aire LLC · Sidney, MTN55LPAir Flight Inc · Fort Lauderdale, FLN5680CSea Spray Aviation LLC · New Smyrna Beach, FLN5688C5688c LLC · Glendale, AZN5690CTailwinds Aircraft Holdings LLC · Harrisburg, NEN569JMInternational Air Services Inc Trustee · Carson City, NVN569PAHerron Aviation Group LLC · Dexter, MIN56GKMatan Kai LLC · West Hollywood, CAN56TJTrue North Aviation LLC · Leclaire, IAN575JBForbes Consolidated Inc · New Smyrna Beach, FLN575SWHester Thomas F · Santa Barbara, CAN57PBHyannis Air Service Inc DBA · Hyannis, MAN5826CBank Of Utah Trustee · Salt Lake City, UTN58AWAmplatz Left Aviation LLC · Rapid City, SDN58HBjk Aviation LLC · Morgantown, WVN596DMAirswiss Inc · Wilmington, DEN598ASAssociated Auction & Liquidation Co · Clarksburg, TNN598DMAirswiss Inc · Wilmington, DEN5AMTexas La Flyers LLC · West Monroe, LAFirst renewal noticeN5CNLewis Gentry Holdings LLC · Orlando, FLN5NMNelson Jeffrey S · Darby, MTN600HCCessna 414a LLC · Portland, OR
Back to AD 2005-12-13