AD 2012-24-03
Registered aircraft · 363
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:2012-24-03')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-24-03')
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:2012-24-03') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-24-03') 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.
N145SDAvera Mckennan · Sioux Falls, SDN145SUAir Methods LLC · Greenwood Village, CON145SZU S Bank Na · Marshall, MNN145THTemsco Helicopters Inc · Ketchikan, AKN145TJAir Methods LLC · Greenwood Village, CON145TNAir Methods LLC · Greenwood Village, CON145TXTexas Department Of Public Safety · Austin, TXN145UCUniversity Of Cincinnati Medical Center LLC · Cincinnati, OHN145WCUc Health LLC · Cincinnati, OHN146HHHartford Hospital · Hartford, CTN146THTemsco Helicopters Inc · Ketchikan, AKN147THTemsco Helicopters Inc · Ketchikan, AKN148THTemsco Helicopters Inc · Ketchikan, AKN149AHAdventist Health System Sunbelt Inc DBA · Altamonte Springs, FLN149THTemsco Helicopters Inc · Ketchikan, AKN14UHLta Group Holdings LLC · Amarillo, TXN153AEPhi Health LLC · Tempe, AZN15NSChopper 3 LLC · Dover, DEN171PDSuffolk County Police Dept · Yaphank, NYN184WKFlight For Life Inc · Waukesha, WIN186ARegistered aircraftN-number assigned, not yet registeredN187AEUS Department Of Homeland Security · Washington, DCN191LLIndiana University Health Inc · Indianapolis, INN192LLIndiana University Health Inc · Indianapolis, INN193LLIndiana University Health Inc · Indianapolis, INN194LLIndiana University Health Inc · Indianapolis, INN195LLIndiana University Health Inc · Indianapolis, INN198LLMetro Aviation Inc · Shreveport, LAN1SDPinellas County Sheriffs Office · Clearwater, FLN203CHCoastal Helicopters Inc · Juneau, AKN2127SEurotec Vertical Flight Solutions LLC · Eudora, KSN214GHCobalt Holdings Inc · Pacoima, CAN216CHCoastal Helicopters Inc · Juneau, AKN216EHBristow LLC · Lake Charles, LAN217FDBristow LLC · Lake Charles, LAN226PDAnaheim Police Dept · Fullerton, CAN234BUHeli-USA Corp · Houston, TXN240SFOsf Aviation LLC · Peoria, ILN244TXBrenthel Industries LLC · Helena, MTN249GSPau Hana Enterprises LLC Series III · Las Vegas, NVN251HIsland Helicopters Kauai Inc · Lihue, HIN261AWAll Wool Aviation LLC · Coral Gables, FLN261MHMetrohealth System · Cleveland, OHN263MHMetrohealth System · Cleveland, OHN266MHMetro Aviation Inc · Shreveport, LAN267MHMetro Aviation Inc · Shreveport, LAN273AMAir Methods LLC · Greenwood Village, CON273NEMetro Aviation Inc · Shreveport, LAN27WAWings Air Helicopters LLC · West Harrison, NYN282SArrow Aviation Company LLC · Broussard, LA
Back to AD 2012-24-03