N791AN
Service difficulty reports · 325
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 = 'N791AN' 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 = 'N791AN' 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 AALA20140616020Lens · missingESCAPE PATH LIGHT AT SEAT 24G MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 24G. OPERATIONS CHECKED NORMAL.SDR AALA20140525001Lens · brokenFORWARD GALLEY LT SIDE EDGE MOUNTED EMERGENCY PROXIMITY LIGHT HAS BROKEN LENS. REPLACED LENS FOR EDGE MOUNTED EMERGENCY LIGHT AT FWD GALLEY. OPERATIONS CHECKED NORMAL.SDR AALA20140416014Light · inoperativeCEILING EMERGENCY LIGHT AT SEAT 35G INOPERATIVE. REPLACED LAMP FOR SEAT 35G CEILING EMERGENCY LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20140416013Light · inoperativeCEILING EMERGENCY LIGHT AT SEAT 40G INOPERATIVE. REPLACED LAMP FOR SEAT 40G CEILING EMERGENCY LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20140416012Light · inoperativeCEILING EMERGENCY LIGHT AT SEAT 24C INOPERATIVE. REPLACED LAMP FOR SEAT 24C CEILING EMERGENCY LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20140416011Light · inoperativeCEILING EMERGENCY LIGHT AT SEAT 21C INOPERATIVE. REPLACED LAMP FOR SEAT 21C CEILING EMERGENCY LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20140416010Light · inoperativeCEILING EMERGENCY LIGHT AT MID GALLEY LT SIDE INOPERATIVE. REPLACED LAMP FOR CEILING EMERGENCY LIGHT AT MID GALLEY LT SIDE. OPERATIONS CHECKED NORMAL.SDR AALA20140416009Light · inoperativeCEILING EMERGENCY LIGHT AT SEAT 4D INOPERATIVE. REPLACED LAMP FOR SEAT 4D CEILING EMERGENCY LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20140414008Light · inoperativeCEILING EMERGENCY LIGHT AT RT NR 1 DOOR INOPERATIVE. REPLACED LAMP FOR CEILING EMERGENCY LIGHT AT RT NR 1 DOOR. OPERATIONS CHECKED NORMAL.SDR AALA20130827010Lens · missingROW 22C ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR ROW 22C ESCAPE PATH LIGHT. OPERATION CHECKED NORMAL.SDR AALA20130827009Light · inoperativeROW 22C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR ROW 22C ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130529007Light · missingESCAPE PATH LIGHT AT SEAT 31C MISSING LAMP. REPLACED LAMP FOR SEAT 31C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130529006Light · missingSEAT 34C, ESCAPE PATH LIGHT MISSING LAMP. REPLACED LAMP FOR SEAT 34C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130529005Light · missingSEAT 20G ESCAPE PATH LIGHT MISSING LAMPS. REPLACED LAMPS FOR SEAT 20G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130529004Light · missingESCAPE PATH LIGHT AT SEAT 30C, MISSING LAMP. REPLACED LAMP FOR SEAT 30C, ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130529003Light · missingESCAPE PATH LIGHT AT SEAT 33C MISSING LAMP. REPLACED LAMP FOR SEAT 33C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130529002Light · missingSEAT 22G, ESCAPE PATH LIGHT MISSING LAMPS. REPLACED LAMPS FOR SEAT 22G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130319027Lens · missingROW 22C ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR ROW 22C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130319026Light · inoperativeROW 22C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR ROW 22C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130319020Battery Pack · dischargedROWS 36 TO 45 ESCAPE PATH LIGHTS INOPERATIVE. REPLACED BATTERY PACK. OPS CHECK NORMAL.SDR AALA20130319019Connector · looseROWS 36 TO 45 IN SEAT ESCAPE PATH LIGHTS FAILED TEST. RE-SECURED LOOSE CONNECTOR AT ROW 34D AND 38D. OPS CHECK NORMAL.SDR AALA20130319018Lens · missingROW 44C ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR ROW 44C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130319017Lens · missingROW 20C ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR ROW 20C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130319016Light · inoperativeROW 20C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR ROW 20C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130319015Lens · missingROW 22C ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR ROW 22C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20130319013Light · inoperativeROW 22C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR ROW 22C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20120927003Light · damagedFIRST CLASS CLOSET EMERGENCY LIGHT ASSEMBLY SHATTERED. REPLACED LIGHT ASSEMBLY FOR FIRST CLASS CLOSET EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20120918013Cover · missingEMERGENCY LIGHT COVER ON FIRST CLASS CLOSET IS MISSING. REPLACED LIGHT ASSEMBLY FOR FIRST CLASS COAT CLOSET LEFT FORWARD EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20120829017Light · inoperativeROW 4DEF ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR ROW 4DEF ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20120829016Lamp · inoperativeROW 34G ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR ROW 34G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20120829015Connector · looseROW 31 ESCAPE PATH LIGHT INOPERATIVE. RECONNECTED LOOSE CONNECTOR UNDERNEATH ROW 31. OPS CHECK NORMAL.SDR AALA20120829014Connector · looseROW 3D ESCAPE PATH LIGHT INOPERATIVE. RECONNECTED LOOSE CONNECTOR FOR ROW 3D ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20120829013Lens · missingROW 23G ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR ROW 23G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20120827016Light · inoperativeROW 23G ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR ROW 23G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20120827012Light · inoperativeROW 26G ESCAPE PATH LIGHT INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR ROW 26G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20120827010Light · inoperativeROW 21C ESCAPE PATH LIGHT ONE LAMP INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR ROW 21C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20120730004Light · inoperativeEMERGENCY LIGHT AT SEAT 22C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 22C. OPS CHECK NORMAL.SDR AALA20120728005Lens · missingEMERGENCY LIGHT AT SEAT 22C MISSING LENS. REPLACED LENS FOR SEAT 22C EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20120728004Lens · missingEMERGENCY LIGHT COVER MISSING AT SEAT 21C. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 21C. OPS CHECK NORMAL.SDR AALA20120722004Probe · inoperativeDFW - CAPTAIN REPORTED THAT LEFT MAIN FUEL QUANTITY INDICATOR WENT BLANK DURING CRUISE. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED NUMBER EIGHTEEN AND TWENTY TANK PROBES. SYSTEM GROUND CHECK NORMSDR AALA20120624004Skin · dentedFOUND DENT FORWARD OF THE LEFT NUMBER 2 DOOR AT STATION 660 BETWEEN STRINGERS 27 AND 28 LEFT. INSTALLED DOUBLER PER SRM 53-00-01-2R 10.SDR AALA20120608017Light · inoperativeLEFT NUMBER 2 DOOR AFT ESCAPE PATH LIGHT HAS ONE LAMP INOPERATIVE. REPLACED LAMP FOR LEFT NUMBER 2 DOOR AFT ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20120608016Lens · missingSEAT 23G ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 23G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20120608015Light · inoperativeSEAT 23G ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 23G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20120426026Battery Pack · dischargedEMERGENCY POWER SUPPLY M33401 AT RIGHT NUMBER 3 DOOR FAILED. REPLACED BATTERY PACK M33401. OPS CHECK NORMAL.SDR AALA20120330013Lens · missingR3 DOOR AFT EMERGENCY LIGHT LENS COVER MISSING. REPLACED EMERGENCY LIGHT LENS COVER AT RIGHT NUMBER DOOR 3. OPS CHECKED NORMAL.SDR AALA20120302018Lens · missingLEFT NUMBER 3 DOOR FORWARD EMERGENCY LIGHT LENS IS MISSING. REPLACED LIGHT ASSEMBLY FOR LEFT NUMBER 3 DOOR FORWARD EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20120302017Light · inoperativeSEAT 1D OVERHEAD EMERGENCY LIGHT IS INOPERATIVE. REPLACED LAMP FOR OVERHEAD EMERGENCY LIGHT AT SEAT 1D. OPS CHECK NORMAL.SDR AALA20111110TUL09Lens · missingSEAT 25D ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 25D ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20111110TUL08Light · missingSEAT 40G ESCAPE PATH LIGHT MISSING LAMP. REPLACED LAMP FOR SEAT 40G ESCAPE PATH LIGHT. OPS CHECK NORMAL.
Back to N791AN