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.
N484LFGeisinger Medical Center · Danville, PAN485ECPitt County Memorial Hospital Inc · Greenville, NCN485LFGeisinger Medical Center · Danville, PAN486LF7513 Helicopter Inc Trustee · Wilmington, DEN487LFGeisinger Medical Center · Danville, PAN488LFSt Lukes University Health Network · Danville, PAN48SEPhi Health LLC · Tempe, AZN491HCBank Of Utah Trustee · Salt Lake City, UTN492HCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN507MECenter For Emergency Medicine Of Western Pa · West Mifflin, PAN509CHChildrens Hospital Colorado · Aurora, CON522MECenter For Emergency Medicine Of Western Pa · West Mifflin, PAN523ECPitt County Memorial Hospital Inc · Greenville, NCN529MDFlight For Life Inc · Waukesha, WIN53HHIntegrity Aircraft Title Holdings LLC · Portland, ORN542AEAirbus Helicopters Inc · Grand Prairie, TXN545DUMetro Aviation Inc · Shreveport, LAN545KFAir Methods LLC · Greenwood Village, CON55UVRector And Visitors Of The Uva Obo Medical Ctr · Charlottesville, VAN575LFWest Penn Allegheny Foundation LLC · Pittsburgh, PAN578AMAir Methods LLC · Greenwood Village, CON585CHAir Methods LLC · Greenwood Village, CON587MHAir Methods LLC · Greenwood Village, CON592ACMetro Aviation Inc · Shreveport, LAN602MMTrustees Of The University Of Pennsylvania · Philadelphia, PAN608UWMetro Aviation Inc · Shreveport, LAN611SJAspirus Wausau Hospital Inc DBA · Wausau, WIN618GLGundersen Lutheran Medical Center Inc · La Crosse, WIN61UPTrustees Of The University Of Pennsylvania · Philadelphia, PAN624ECPitt County Memorial Hospital Inc · Greenville, NCN635TJAir Methods LLC · Greenwood Village, CON648BHFlight For Life Inc · Waukesha, WIN676LFWest Penn Allegheny Foundation LLC · Pittsburgh, PAN745TXMother Frances Hospital Regional Health Care Ctr · Tempe, AZN74GHGuardian Helicopters Inc · Fillmore, CAN759BHAir Methods LLC · Greenwood Village, CON766MEAir Methods LLC · Greenwood Village, CON770WSMetro Aviation Inc · Shreveport, LAN779LFAir Methods LLC · Greenwood Village, CON787RCRegistered aircraftN78NCAir Methods LLC · Greenwood Village, CON8118YSanborn Richard E Trustee · Bethlehem, NHN814LVAir Methods LLC · Greenwood Village, CON816ECPitt County Memorial Hospital · Greenville, NCN824EHMetro Aviation Inc · Shreveport, LAN84UCUc Health LLC · Cincinnati, OHN850UWMetro Aviation Inc · Shreveport, LAN854ECPitt County Memorial Hospital Inc · Greenville, NCN874BUMetro Aviation Inc · Shreveport, LAN87MECenter For Emergency Medicine Of Western Pa · West Mifflin, PA
Back to AD 2012-13-11