AD 2011-17-15
Registered aircraft · 221
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-17-15')
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-17-15')
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:2011-17-15') 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-17-15') 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.
N22DKEquity Partner LLC · Wilmington, DEN241DENorthgate Aviation LLC · Colorado Springs, CON247RWBank Of Utah Trustee · Salt Lake City, UTN24PFPsf Aviation LLC · Ponte Vedra Beach, FLN250RMAdjacent Air LLC · Holdrege, NEN255AMPreferred Aviation LLC · Fayetteville, ARN255KMAir Castle LLC · Valdosta, GAN258PVAdams Aviation Services Inc Trustee · Wilmington, DEN259DC295 Holdings LLC · Chico, CAN264AGSugarland Phenom LLC · Charlotte, NCN270EAMk Aviation LLC · Westlake, LAN277BGKap Holdings Sulphur LLC · Sulphur, LAN27DKLgp Holding LLC · Wilmington, DEN27XPRavello LLC · Tulsa, OKN285GCDelaware Aviation LLC · Dover, DEN287STProtyme LLC · Wilmington, DEN288DXQuest Diagnostics Clinical Laboratories Inc · Reading, PAN289RZSpire Aviation II LLC · Mooresville, NCN300LJAircraft Trustee Services Inc Trustee · Dover, DEN302MDDmgv Air LLC · Jonesboro, ARN303MTG-4 Aviation LLC · Wendell, NCN305PLLifestyle Aviation LLC · Key Biscayne, FLN316BLKuhl LLC · Dover, DEN316NNicholas Services LLC · Oxford, MSN321KM53wa LLC · Prairieville, LAN325FPS2t LLC · Naples, FLN325TXConcho Flight Support LLC · San Angelo, TXN327HFSig Aero LLC · Lewes, DEN32JANorsan Aviation LLC · Duluth, GAN32KETaildragger LLC · Pocatello, IDN337HCElektra Air LLC · New York, NYN337VBDmb LLC · Wilmington, DEN342NXValiair Lc Trustee · Casper, WYN347HMSilverwings LLC · Birmingham, ALN347PGLand Air Sea Systems Inc · Kenosha, WIN348NVivid Aviation LLC · La Jolla, CAN353SBEasy Jet LLC · Menifee, CAN356NNicholas Services LLC DBA · Oxford, MSN365PFStraightline Properties LLC · Houston, TXN367ERJetscape Business Aviation LLC · Fort Lauderdale, FLN369AXAtaraxia Aircraft Holdings LLC · Greenville, SCN371VABank Of Utah Trustee · Salt Lake City, UTN374NNicholas Services LLC · Oxford, MSN390TPRiddles Group Inc · Rapid City, SDN39KGo Fast Inc · Wakefield, MAN39PWRuff Co 1 LLC · Bloomer, WIN3JGJrg LLC · Lake Charles, LAN400EPTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN400QFLisha Investments LLC · Beverly Hills, CAN421AJEmpire Airlines Inc · Lebanon, MO
Back to AD 2011-17-15