AD 2012-23-12
Registered aircraft · 182
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-23-12')
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-23-12')
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-23-12') 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-23-12') 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.
N194LLIndiana University Health Inc · Indianapolis, INN195LLIndiana University Health Inc · Indianapolis, INN198LLMetro Aviation Inc · Shreveport, LAN240SFOsf Aviation LLC · Peoria, ILN261MHMetrohealth System · Cleveland, OHN263MHMetrohealth System · Cleveland, OHN266MHMetro Aviation Inc · Shreveport, LAN267MHMetro Aviation Inc · Shreveport, LAN273AMAir Methods LLC · Greenwood Village, CON273NEMetro Aviation Inc · Shreveport, LAN282SArrow Aviation Company LLC · Broussard, LAN30EZHover Air LLC · Anchorage, AKFirst renewal noticeN340SFOsf Aviation LLC · Peoria, ILN350MPCity Of Memphis Police Department · Memphis, TNN351HDT Scott Dunn Construction Inc · Phoenix, ORN352RNs Air Leasing LLC · Wilmington, DEN353PPhi Health LLC · Tempe, AZN354PPhi Health LLC · Tempe, AZN357PAPathfinder Leasing LLC · Anchorage, AKN358TVTiny Bubbles Aviation Inc · Pacoima, CAN365UCAir Methods LLC · Greenwood Village, CON373LFWest Penn Allegheny Foundation LLC · Pittsburgh, PAN375AHBank Of Utah Trustee · Salt Lake City, UTN376AHBank Of Utah Trustee · Salt Lake City, UTN387AK387ak LLC · Anchorage, AKN390FDReach Air Medical Services LLC · Santa Rosa, CAN399PHPhi Health LLC · Tempe, AZFirst renewal noticeN39VATriple M Leasing LLC · Shreveport, LAN3PDSuffolk County Police Dept · Yaphank, NYN401MFDare County · Manteo, NCN402CNChildren'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, LAN44DSDs Air II LLC · Carrollton, VAN452MHCharlotte 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, PAN47UHUniversity 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-23-12