AD 2012-13-11
Registered aircraft · 178
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-13-11')
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-13-11')
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-13-11') 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-13-11') 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.
N171PDSuffolk County Police Dept · Yaphank, NYN184WKFlight For Life Inc · Waukesha, WIN186ARegistered aircraftN-number assigned, not yet registeredN191LLIndiana 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, LAN198LSMetro Aviation Inc · Shreveport, LAN240SFOsf Aviation LLC · Peoria, ILN261MHMetrohealth System · Cleveland, OHN262MHMetrohealth System · Cleveland, OHN263MHMetrohealth System · Cleveland, OHN266MHMetro Aviation Inc · Shreveport, LAN267MHMetro Aviation Inc · Shreveport, LAN273NEMetro Aviation Inc · Shreveport, LAN304MECenter For Emergency Medicine Western Pennsylvania · West Mifflin, PAN307MECenter For Emergency Medicine Western Pennsylvania · West Mifflin, PAN340SFOsf Aviation LLC · Peoria, ILN365UCAir Methods LLC · Greenwood Village, CON373LFWest Penn Allegheny Foundation LLC · Pittsburgh, PAN381MSAir Methods LLC · Greenwood Village, CON38VABrown Helicopter Inc · Pensacola, FLN390FDReach Air Medical Services LLC · Santa Rosa, CAN399HHIntegrity Aircraft Title Holdings LLC · Portland, ORN399PHPhi Health LLC · Tempe, AZFirst renewal noticeN39VATriple M Leasing LLC · Shreveport, LAN3PDSuffolk County Police Dept · Yaphank, NYN402CNChildren'S Hospital & Medical Center DBA · Omaha, NEN406BCMetro Aviation Inc · Shreveport, LAN406GFMetro Aviation Inc · Shreveport, LAN440SFOsf Aviation LLC · Peoria, ILN445CHEgleston Childrens Hospital At Emory Univ Inc DBA · Atlanta, GAN445DUMetro Aviation Inc · Shreveport, LAN448CHMetro Aviation Inc · Shreveport, LAN452MHCharlotte Mecklenburg Hospital Authority DBA · Charlotte, NCN453MHMemorial Hermann Health System · Houston, TXN455MHMemorial Hermann Health System · Houston, TXN456TKMemorial Hermann Health System · Houston, TXN45UHUniversity Of Utah · Salt Lake City, UTN46UHUniversity Of Utah · Salt Lake City, UTN474LFWest Penn Allegheny Health System Inc · Pittsburgh, PAN477CSRegistration Pending · Spearfish, SDRegistration pendingN478CSRegistration Pending · Spearfish, SDRegistration pendingN47UHUniversity Of Utah · Salt Lake City, UTN480LFGeisinger Medical Center · Danville, PAN481LFGeisinger Medical Center · Danville, PAN482LFGeisinger Medical Center · Danville, PAN483LFGeisinger Medical Center · Danville, PA
Back to AD 2012-13-11