N766AN
Service difficulty reports · 237
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE n_number = 'N766AN' AND registry_match = 'registration' ORDER BY difficulty_date DESC"
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 sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE n_number = 'N766AN' AND registry_match = 'registration' ORDER BY difficulty_date DESC
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.
SDR AALA20140605017Light · missingESCAPE PATH LIGHT AT SEAT 31C MISSING LAMP. REPLACED LAMP FOR ESCAPE PATH LIGHT AT SEAT 31C. OPERATIONS CHECKED NORMAL.SDR AALA20140605016Light · missingESCAPE PATH LIGHT AT SEAT 26C MISSING LAMP. REPLACED LAMP FOR ESCAPE PATH LIGHT AT SEAT 26C. OPERATIONS CHECKED NORMAL.SDR AALA20140605015Light · missingESCAPE PATH LIGHT AT SEAT 25C MISSING LAMP. REPLACED LAMP FOR ESCAPE PATH LIGHT AT SEAT 25C. OPERATIONS CHECKED NORMAL.SDR AALA20140605014Lens · missingESCAPE PATH LIGHT AT SEAT 36G MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 36G. OPERATIONS CHECKED NORMAL.SDR AALA20140605013Light · missingESCAPE PATH LIGHT AT SEAT 36G MISSING LAMP. REPLACED LAMP FOR ESCAPE PATH LIGHT AT SEAT 36G. OPERATIONS CHECKED NORMAL.SDR AALA20140605012Light · missingESCAPE PATH LIGHT AT SEAT 41G MISSING LAMP. REPLACED LAMP FOR ESCAPE PATH LIGHT AT SEAT 41G. OPERATIONS CHECKED NORMAL.SDR AALA20140605011Lens · missingESCAPE PATH LIGHT AT SEAT 24C MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 24C. OPERATIONS CHECKED NORMAL.SDR AALA20140605010Light · missingESCAPE PATH LIGHT AT SEAT 24C MISSING LAMP. REPLACED LAMP FOR ESCAPE PATH LIGHT AT SEAT 24C. OPERATIONS CHECKED NORMAL.SDR AALA20140605009Light · missingESCAPE PATH LIGHT AT SEAT 45C MISSING LAMP. REPLACED LAMP FOR ESCAPE PATH LIGHT AT SEAT 45C. OPERATIONS CHECKED NORMAL.SDR AALA20140605008Light · missingESCAPE PATH LIGHT AT SEAT 44C MISSING LAMP. REPLACED LAMP FOR ESCAPE PATH LIGHT AT SEAT 44C. OPERATIONS CHECKED NORMAL.SDR AALA20140605007Light · missingESCAPE PATH LIGHT AT SEAT 39C MISSING LAMP. REPLACED LAMP FOR ESCAPE PATH LIGHT AT SEAT 39C. OPERATIONS CHECKED NORMAL.SDR AALA20140603013Lens · missingESCAPE PATH LIGHT AT SEAT 31C MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 31C. OPERATIONS CHECKED NORMAL.SDR AALA20140603012Lens · missingESCAPE PATH LIGHT AT SEAT 26C MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 26C. OPERATIONS CHECKED NORMAL.SDR AALA20140603011Lens · missingESCAPE PATH LIGHT AT SEAT 25C MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 25C. OPERATIONS CHECKED NORMAL.SDR AALA20140603010Lens · missingESCAPE PATH LIGHT AT SEAT 41G MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 41G. OPERATIONS CHECKED NORMAL.SDR AALA20140603009Lens · missingESCAPE PATH LIGHT AT SEAT 45C MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 45C. OPERATIONS CHECKED NORMAL.SDR AALA20140603008Lens · missingESCAPE PATH LIGHT AT SEAT 44C MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 44C. OPERATIONS CHECKED NORMAL.SDR AALA20140603007Lens · missingESCAPE PATH LIGHT AT SEAT 39C MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 39C. OPERATIONS CHECKED NORMAL.SDR AALA20140604012Light · missingESCAPE PATH LIGHT AT SEAT 33C MISSING LAMP. REPLACED LAMP FOR ESCAPE PATH LIGHT AT SEAT 33C. OPERATIONS CHECKED NORMAL.SDR AALA20140603006Lens · missingESCAPE PATH LIGHT AT SEAT 33C MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 33C. OPERATIONS CHECKED NORMAL.SDR AALA20140313012Battery Pack · dischargedESCAPE PATH LIGHTS AT CLASS DIVIDER BOTH SIDES AT ROW 20 INOPERATIVE. REPLACED BATTERY PACK, OPERATIONS CHECKED NORMAL.SDR AALA20140313011Battery Pack · dischargedFORWARD ESCAPE PATH LIGHTS AT RT NR 4 DOOR. REPLACED BATTERY PACK M33409 FOR RT NR 4 DOOR FWD ESCAPE PATH LIGHTS, OPERATIONS CHECKED NORMAL.SDR AALA20140313010Battery Pack · dischargedAFT ESCAPE PATH LIGHTS AT RT NR 4 DOOR. REPLACED BATTERY PACK FOR RT NR 4 DOOR AFT ESCAPE PATH LIGHTS, OPERATIONS CHECKED NORMAL.SDR AALA20140313009Battery Pack · dischargedAFT ESCAPE PATH LIGHTS AT LT NR 4 DOOR. REPLACED BATTERY PACK FOR LT NR 4 DOOR AFT ESCAPE PATH LIGHTS, OPERATIONS CHECKED NORMAL.SDR AALA20140313008Battery Pack · dischargedFORWARD ESCAPE PATH LIGHTS AT LT NR 4 DOOR. RECHARGED BATTERY PACK FOR LT NR 4 DOOR FORWARD ESCAPE PATH LIGHTS, OPERATIONS CHECKED NORMAL.SDR AALA20140313007Battery Pack · dischargedFORWARD ESCAPE PATH LIGHTS AT RT NR 2 DOOR. RECHARGED BATTERY PACK FOR RT NUMBER 2 DOOR FWD ESCAPE PATH LIGHTS, OPERATIONS CHECKED NORMAL.SDR AALA20140313004Battery Pack · dischargedESCAPE PATH LIGHT AT AFT LT NR 2 DOOR INOPERATIVE. RECHARGED BATTERY PACK FOR ESCAPE PATH LIGHT AT AFT LT NR 2 DOOR, OPERATIONS CHECKED NORMAL.SDR AALA20140313003Light · inoperativeLEFT NR 2 DOOR CEILING LIGHT INOPERATIVE. REPLACED OVERHEAD LIGHT ASSEMBLY AT LT NR 2 DOOR, OPERATIONS CHECKED NORMAL.SDR AALA20131203004Lens · missingSEAT 33C EMERGENCY ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR EMERGENCY ESCAPE PATH LIGHT AT SEAT 33C. OPERATIONS CHECKED NORMAL.SDR AALA20131125012Light · missingSEAT 33C EMERGENCY ESCAPE PATH LIGHT MISSING LAMP. REPLACED LAMP FOR EMERGENCY ESCAPE PATH LIGHT AT SEAT 33C, OPERATIONS CHECKED NORMAL.SDR AALA20130905010Lens · missingOVERHEAD EMERGENCY LIGHT BY SEAT 42G MISSING LENS. REPLACED LENS FOR OVERHEAD EMERGENCY LIGHT BY SEAT 42G. OPERATIONS CHECKED NORMAL.SDR AALA20130711003Lens · missingSEAT 25C EMERGENCY PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 25C ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130525008Light · inoperativeESCAPE PATH LIGHT AT SEAT 24C INOPERATIVE. REPLACED LAMP FOR SEAT 24C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130525007Light · inoperativeESCAPE PATH LIGHT AT SEAT 20C INOPERATIVE. REPLACED LAMP FOR SEAT 20C ESCAPE PATH LIGHT. OPS CHECK NORMALSDR AALA20130525006Light · inoperativeESCAPE PATH LIGHT AT SEAT 43C INOPERATIVE. REPLACED LAMP FOR SEAT 43C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130525005Light · inoperativeESCAPE PATH LIGHT AT SEAT 39C INOPERATIVE. REPLACED LAMP FOR SEAT 39C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130319010Lens · missingSEAT 21C ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 21C EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20130316012Light · missingSEAT 21C ESCAPE PATH LIGHT MISSING LAMP. REPLACED LAMP FOR SEAT 21C EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20130316011Lens · missingSEAT 26G ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 26G EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20130316010Light · inoperativeSEAT 31G ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 31G EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20130316009Light · inoperativeSEAT 32C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 32C EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20130316008Light · inoperativeSEAT 45C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 45C EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20130319009Lens · missingSEAT 24C ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 24C EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20130316007Light · inoperativeSEAT 41C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 41C EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20130316006Light · inoperativeSEAT 22C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 22C EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20130316005Light · missingSEAT 24C ESCAPE PATH LIGHT MISSING LAMP. REPLACED LAMP FOR SEAT 24C EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20130314001Light · brokenTHE FIRST CLASS CLOSET REFLECTOR LIGHT AT THE BOTTOM RIGHT AND SIDE IS BROKEN AND SHARP. REPLACED FIRST CLASS COAT CLOSET EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20130129013Light · damagedEMERGENCY LIGHT AT FORWARD CLOSET DAMAGED. REPLACED LAMP FOR EMERGENCY LIGHT AT FORWARD CLOSET. OPS CHECK NORMAL.SDR AALA20121227004Light · inoperativeROW 31G CEILING ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR ROW 31G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20121227003Light · inoperativeROW 24C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR ROW 24C ESCAPE PATH LIGHT. OPS CHECK NORMAL.
Back to N766AN