AD 2011-25-01
Registered aircraft · 2,822
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-25-01')
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-25-01')
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-25-01') 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-25-01') 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.
N17592Premier Rotors LLC · Saint Martinville, LAN175MSFlorida Keys Mosquito Control District · Marathon, FLN175PAMansfield Helifight · Milton, VTN176AEAir Evac Ems Inc · Ofallon, MON176PGreenfield Kevin G Trustee · Anchorage, AKN176PDElon Management LLC · Salem, ORN178PAOrlando Aircraft Sales LLC · Orlando, FLN179RLRotorcraft Leasing Co LLC · Broussard, LAN179SFN179sf LLC · Chandler, AZN17DEBell Textron Inc · Fort Worth, TXN17DFDf Aviation LLC · Somerset, KYN17LASan Juan Aviation LLC · Wilmington, DEN17NRTrans 5 Investments LLC · Saint Martinville, LAN17NXTrans 5 Investments LLC · Saint Martinville, LAN17SPNew York State Police · Albany, NYN17TLTurbines Ltd · West Point, NEN17TWWhirlybird Aviation LLC · Bend, ORN1807Gm Leasing Co LLC · Broussard, LAN181MAMinuteman Aviation Inc · Missoula, MTN1821Gm Leasing Co LLC · Broussard, LAN182AAIndustrial Helicopters LLC · Lafayette, LAN183DHSouthern Aircraft Consultancy Inc Trustee · Casper, WYN183TCLarson Dylan J · Perham, MNN184AMAir Methods LLC · Greenwood Village, CON184SFGm Leasing Co LLC · Broussard, LAN189AMAir Methods LLC · Greenwood Village, CON189RLL&R Investment Partners LLC · Wilmington, DEN18BHAbc Helicopters Inc · Jefferson, WIN18DBN87bb LLC · Monroe, NCN18LACounty Of Los Angeles Fire Department · Pacoima, CAN18SPState Of New York · Albany, NYN1903ADale County Sheriffs Office · Ozark, ALN1909RCenterline Holdings · Camden, DEN190AETextron Financial Corp · Wichita, KSN190RHLiberty Blades LLC · Flandreau, SDN191SGAngel William D · Rancho Cucamonga, CAN192AEAir Evac Ems Inc · O Fallon, MON192RLRotorcraft Leasing Co LLC · Broussard, LAN192TAHawkeye Helicopter LLC · Lyndon, KSN193AETextron Financial Corp · Wichita, KSN193ALBlade Leasing LLC · Homer, AKN193AMAir Methods LLC · Greenwood Village, CON193ATBell Textron Inc · Fort Worth, TXN193BMBell Textron Inc · Fort Worth, TXN194TAJsj Aviation LLC · Helena, MTN1957ZDakota Rotors LLC · Custer, SDN195DJN195dj LLC · Brooklyn, NYN196AEAir Evac Ems Inc · O Fallon, MON196SJSan Juan Aviation LLC · Wilmington, DEN196TAHelo N426ha LLC · Richmond, VA
Back to AD 2011-25-01