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.
N135EDAir Methods LLC · Greenwood Village, CON135GFMetro Aviation Inc · Shreveport, LAN135LCAir Methods LLC · Greenwood Village, CON135LLMercy Hospital Springfield · Springfield, MON135LXMed-Trans Corp · Denton, TXN135MFZmog Management Company LLC · Folsom, CAN135MHBay Life Services Corp · Columbia, MDN135MLCsc Delaware Trust Co Trustee · Wilmington, DEN135NMh Hospital Manager LLC · Asheville, NCN135NKAir Methods LLC · Greenwood Village, CON135TGAir Methods LLC · Greenwood Village, CON135TJAir Methods LLC · Greenwood Village, CON135UTMed-Trans Corp · Denton, TXN135VVMed Trans Corp · Denton, TXN135WJAir Methods LLC · Greenwood Village, CON135WLMed-Trans Corp · Denton, TXN1368XLinscott Jeffrey R · Boring, ORN136JSBettencourt Flg Svc Inc · Atwater, CAN136KYAir Methods LLC · Greenwood Village, CON136MFAir Methods LLC · Greenwood Village, CON136TWSilver Creek Aviation Services · Fort Worth, TXN136UTMed-Trans Corp · Denton, TXN136VAAir Methods LLC · Greenwood Village, CON137AGTop Gun Precision Ag LLC · Skidmore, TXN137AMAir Methods LLC · Greenwood Village, CON137HSHelicopter Services Of Illinois LLC · Fisher, ILN137MScotts Helicopter Services Inc · Le Sueur, MNN137MHMetro Aviation Inc · Shreveport, LAN137MMAircraft Guaranty Corp Trustee · Oklahoma City, OKN137MSKansas State University · Salina, KSN137PDPuerto Rico Police Department · San Juan, PRN138AEAir Evac Ems Inc · O Fallon, MON138DDDalton Aviation LLC · Bluffdale, UTN138HNAir Methods LLC · Greenwood Village, CON138LHHelilease LLC · Lewes, DEN138LNAir Methods LLC · Greenwood Village, CON138PDPuerto Rico Police Department · San Juan, PRN139MHMetro Aviation Inc · Shreveport, LAN139PDPuerto Rico Police Dept · San Juan, PRN139TCBell Textron Inc · Fort Worth, TXN139TJAir Methods LLC · Greenwood Village, CON13FBFirebird Holdings LLC · Fort Worth, TXN13FQFly Hangar 13 LLC · Mico, TXN13FV22t Aero LLC · Anchorage, AKN13FWFly Hangar 13 LLC · Mico, TXN13HDHelicopters Inc · Wilmington, DEN13MXBank Of Utah Trustee · Salt Lake City, UTN13NNHelicopters Inc · Wilmington, DEN13QBFly Hangar 13 LLC · Mico, TXN13TZAerospace Trust Management LLC Trustee · Wilmington, DE
Back to AD 2011-25-01