N912AN
Service difficulty reports · 220
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 = 'N912AN' 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 = 'N912AN' 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 AALA202307058567Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN FLOOR SUPPORT AT BS 993 AND RBL 41. REPLACED FLOOR SUPPORT PER SRM 51-40-02.SDR AALA202307053391Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN FLOOR SUPPORT AT BS 993 AND RBL 41. REPLACED FLOOR SUPPORT PER SRM 51-40-02.SDR AALA202307039812Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CABIN FLOOR BEAM AT BS 986.5 AND LBL 44. REPAIRED FLOOR BEAM PER SRM 53-70-51.SDR AALA202306308784Floor Panel · delaminatedAIRCRAFT IN BASE MAINTENANCED: FLOOR PANEL 242GF HAS 3 CORNERS DELAMINATED AND HONEYCOMB DAMAGE ALONG EDGES. REPAIRED FLOOR PANEL PER SRM 53-00-50-2R.SDR AALA202306309106Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: FORWARD CABIN FLOOR INTERCOSTAL CRACKED AT FASTENER HOLE UNDER FLOOR PANEL 221CF AT BS 320 AT LBL 48. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA202306309384Support Angle · crackedAIRCRAFT IN BASE MAINTENANCE: FORWARD CABIN FLOOR SUPPORT ANGLE FORWARD FASTENER HOLE CRACKED UNDER FLOOR PANEL 221AF AT BS 260 BETWEEN LBL 24.75 AND RBL 24.75. REPLACED SUPPORT ANGLE PER SRM 51-40-02.SDR AALA202307281825Unknown · unknownAIRCRAFT IN BASE MAINTENANCE: LAVATORY A EXIT LIGHT BROKEN. **SUPPLEMENTAL REPORT FOR AALA202306141825: REPLACED LIGHT ASSEMBLY PER AMM 33-26-03.** (CLOSED)SDR AALA202306303032Floorboard · delaminatedAIRCARFT IN BASE MAINTENANCE: FLOORBOARD 241UF IS DELAMINATED. REPLACED FLOORBOARD.SDR AALA202306303784Floorboard · delaminatedAIRCRAFT IN BASE MAINTENANCE: FLOORBOARD 222AAA IS DELAMINATED. REPLACED FLOORBOARD PER AMM 53-21-00.SDR AALA202306301802Floorboard · delaminatedAIRCRAFT IN BASE MAINTENANCE: FLOORBOARD 242EF IS DELAMINATED. REPLACED FLOORBOARD PER AMM 53-21-00.SDR AALA202306301195Floorboard · delaminatedAIRCRAFT IN BASE MAINTENANCE: FLOORBOARD 247ABA IS DELAMINATED. REPLACED FLOORBOARD.SDR AALA202306309853Floorboard · delaminatedAIRCRAFT IN BASE MAINTENANCED: FLOORBOARD 221CF IS DELAMINATED. REPLACED FLOORBOARD PER AMM 53-21-00.SDR AALA202306141825Unknown · unknownAIRCRAFT IN BASE MAINTENANCE: LAVATORY A EXIT LIGHT BROKEN. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202308213333Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED: DURING DESCENT SMOKE DETECTOR IN 1ST CLASS LAVATORY ACTIVATED; HOWEVER, NO SMOKE OR FIRE WAS PRESENT. SMOKE DETECTOR WAS RESET. **SUPPLEMENTAL REPORT FOR AALA202306053333: REPLACED LAVATORY SMOKE DETECTOR PER AMM 26-14-01-000-801. ACSDR AALA202306053333Unknown · unknownAIRCRAFT WAS NOT GROUNDED: DURING DESCENT SMOKE DETECTOR IN 1ST CLASS LAVATORY ACTIVATED; HOWEVER, NO SMOKE OR FIRE WAS PRESENT. SMOKE DETECTOR WAS RESET. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA201908279007Flashlight · inoperativeAIRCRAFT NOT GROUNDED: EMERGENCY FLASHLIGHT WILL NOT TEST. UNDER F/A SEAT FWD INBD POSITION. REPLACED BATTERY PACK AND SEAL ON FWD INBD EMERGENCY FLASHLIGHT IAW AMM 25-64-00. OK FOR SERVICE.SDR AALA2019080539003Cover · brokenAIRCRAFT WAS NOT GROUNDED: LEFT AFT GALLEY EMERGENCY EXIT LIGHT COVER WAS BROKEN. REPLACED LENS COVER PER STANDARD PRACTICES.SDR AALA201902109010Slide · unsecureAIRCRAFT WAS GROUNDED: FLIGHT ATTENDANT DISARMED FORWARD EXIT DOOR, UPON GATE ARRIVAL, BUT AFTER OPENING THE DOOR THE SLIDE BAR FELL OUT AND GOT STUCK WITH THE SLIDE PARTIALLY OUT. MAINTENANCE REPLACED L1 DOOR SLIDE PER AMM25-66-01 AND PERFORMED SATISFACTORY OSDR AALA201812049003Smoke Detector · false activationLAVATORY SMOKE LIGHT ILLUMINATED IN FLIGHT FOR ABOUT ONE MINUTE. ALARM SOUNDED IN LAVATORY IN A NON- CONTINUOUS MANNER. NO SMOKE PRESENT DUIRNG INSPECTION. ACCOMPLISHED A SELF TEST OF THE AFT LEFT LAVATORY SMOKE DETECTOR IAW MM 26-14-00. CHECKED OK. ACFT OSDR AALA201811139016Trim Motor · faultyTHE AIRCRAFT WAS GROUNDED. DURING DESCENT, THE STAB OUT OF TRIM LIGHT ILLUMINATED. PERFORMED THE QRH PROCEDURE. AUTO PILOT TRIM INOPERATIVE. MAIN ELECTRIC TRIM WAS ALSO INOPERATIVE. THE FLIGHT DECLARED AN EMERGENCY AND DIVERTED TO JFK. PERFORMED QRH PROCEDURESDR AALA2018091439032Sign · missingCABIN EMERGENCY EXIT SIGN ON SIDWALL, JUST BEHIND FORWARD GALLEY OVENS, WAS MISSING. MAINTENANCE REPLACED THE EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-14 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA2018080769049Sliding Window · faultyCAPTAIN`S SLIDING WINDOW WAS VERY DIFFICULT TO OPEN AND CLOSE, LATCHING AND UNLATCHING REQUIRED EXCESSIVE FORCE. THE AIRCRAFT WAS GROUNDED. MAINTENANCE ADJUSTED UPPER CONTROL HOUSING IAW AMM 56-12-11, AND PERFORMED SATISFACTORY OPS CHECK.SDR AALA201807209014Window · faultyAIRCRAFT WAS GROUNDED: CAPTAIN'S WINDOW WAS VERY DIFFICULT TO CLOSE, DID NOT OPERATE SMOOTHLY. MAINTENANCE REPLACED CAPTAIN'S WINDOW NR 2 PER AMM 56-12-11 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201802289026Cover · missingAIRCRAFT WAS NOT GROUNDED: RIGHT AFT EMERGENCY EXIT SIGN COVER MISSING. MAINTENANCE REPLACED RIGHT AFT EMERGENCY EXIT SIGN COVER PER AMM 33-51-00 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA20180128010Valve · failedFUEL IMBALANCE MESSAGE, AMBER INDICATION ON DURING CLIMB, LEFT GAUGE 8.38 RT GAGE 7.45 . AN EMERGENCY WAS DECLARED AND AIRCRAFT RETURNED TO DEPARTURE, LANDED WITHOUT INCIDENT. ACCOMPLISHED FQIS BITE CHECK, NO FAULTS NOTED IAW AMM 28-41-00. ACCOMPLISHED QSDR AALA201712159027Slide · displacedAIRCRAFT WAS NOT GROUNDED. A SMALL PORTION OF THE FORWARD ENTRY DOOR SLIDE PACK APPEARS TO BE PROTRUDING AT THE BOTTOM OF ITS CONTAINER. INSPECTED FWD ENTRY DOOR SLIDE PACK AND HOUSING. NO FAULTS NOTED PER AMM 25-66-00.SDR AALA201710119009Proximity Sensor · faultedEMERGENCY DECLARED. LEADING EDGE FLAPS TRANSIT LIGHT ILLUMINATED DURING FLIGHT. STAYED ON AS FLAPS WERE EXTENDED. FLAPS WERE CYCLED UP AND DOWN AFTER PASSING BELOW 20,000 FEET. CREW RAN THE QRH PROCEDURES AND LANDED THE AIRCRAFT WITH FLAPS SET AT 15. LANDISDR AALA201709259030Girt Bar · stuckAIRCRAFT WAS NOT GROUNDED. R1 DOOR EMERGENCY EVACUATION SLIDE GIRT BAR IS STUCK ON DOOR. REMOVED AND REPLACED SLIDE PER AMM 25-66-01. OPERATIONAL CHECK GOOD.SDR AALA201708119020Gust Lock · defectiveTHE AIRCRAFT WAS NOT GROUNDED. LEFT AFT SERVICE DOOR GUST LOCK PIN IS MISSING PIN TOP AND SPRING. DOOR WILL LOCK OPEN BUT IS MISSING ABOVE TO UNLOCK & CLOSE DOOR. REPLACED LEFT AFT ENTRY DOOR GUST LOCK PIN TOP IAW AMM 52-13-00. OPS CHECKS OK.SDR AALA201705259025Lens · missingEMERGENCY EXIT LIGHT LENS MISSING FWD GALLEY. REPLACED THE LENS IAW AMM 33-51-00. OPS CHECKED OK.SDR AALA201705099041Inverter · inoperativeMID. DESCENT 24K STRONG ELECTRICAL FUME SMELL. RAN SMOKE, FIRE , OR FUMES CHECKLIST PER QRH. THE FLIGHT DECLARED AN EMERGENCY. SAFELY LANDED DESTINATION WITH FUMES PARTIALLY DISAPPEARED. ACCOMPLISHED MCM 05-96-70, FOUND STATIC INVERTER INOP AND STRONG SMELL INSDR AALA201704199021Smoke Detector · defectiveGOT LAV SMOKE LIGHT AND AURAL WARNING IN C/P. NR 1 FA GOT 1 LAV SMOKE WARNING MULTIPLE CHECKS SHOWED NO SMOKE, SMELL OR OTHER INDICATIONS OF FIRE. REMOVED AND REPLACED LAV 1 SMOKE DETECTOR IAW AMM 26-14-01. OP CHECKED GOOD. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA20170208015Tube · crackedAIRCRAFT WAS GROUNDED. DURING CLIMB, BOTH LEFT AND RIGHT LOW PRESSURE LIGHTS ILLUMINATED. CENTER TANK FUEL MIGRATION/IMBALANCE. REMOVED AND REPLACED CENTER TANK FUEL CROSSFEED TUBE ASSEMBLY IAW AMM 28-22-15-400-801. LEAK AND OPERATIONAL CHECK GOOD.SDR AALA20170201029Pump · faultyAIRCRAFT WAS GROUNDED. AFTER BURNING CENTER TANK DOWN TO ZERO, WITH CENTER PUMP OFF, CENTER TANK QUANTITY INCREASED. REMOVED AND REPLACED LEFT WING FUEL SCAVENGE JET PUMP IAW AMM 28-22-17. LEAK AND OPERATIONAL CHECK GOOD.SDR AALA20170110005Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT AT SEATS 16ABC IS MISSING THE LENS COVER. INSTALLED LENS COVER IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170110004Bearing · faultyAIRCRAFT WAS GROUNDED. L1 DOOR DIFFICULT TO CLOSE. ADJUSTED LOWER AND UPPER GATE TO TOLERANCE. REMOVED AND REPLACED UPPER AFT BEARING ON L1 DOOR IAW AMM 52-11-00-820-801. OPERATIONAL CHECK GOOD.SDR AALA20161213020Connector · dirtyAIRCRAFT NOT GROUNDED. TEN MINUTES INTO FLIGHT, RIGHT FORWARD FUEL PUMP LOWER PRESSURE LIGHT ILLUMINATED. CLEANED CONNECTOR ON PUMP LOW PRESSURE SWITCH IAW FIM 28-22-00-810-806. OPERATIONAL CHECK GOOD.SDR AALA20161121003Transmitter · faultyEMERGENCY DECLARED. LANDING UNEVENTFUL. DURING APPROACH FLAPS FAILED TO EXTEND TO 1 WITH HANDLE AT FLAP 1. TRAILING EDGE FLAP TRANSIT LIGHT ILLUMINATED. LANDED WITH FLAPS 15 USING ALTERNATE FLAP EXTENSION. REMOVED AND REPLACED LEFT WING FLAP POSITION TRANSMITTSDR AALA20161107018Lens · missingAIRCRAFT NOT GROUNDED. RIGHT AFT DOOR MISSING EMERGENCY EXIT SIGN LENS COVER. INSTALLED LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20150904005Pressure Deck · canningLEFT REAR SPAR VERTICAL PRESS DECK OF CTR WING BOX WEB WAS FOUND TO BE IN A DEFLECTION OIL CAN SITUATION. AFTER DAMAGE REMOVAL OF THE WEB OIL CANNING AREAS LBL 21 TO THE OTBD END LBL 45, DID COMPLETE THE SRM 57-10-10-2R-3 ALT 2 REPAIR ALL IAW EA 254061 & 8100SDR AALA20150831004Bulkhead · canningPRESSURE BULKHEAD AT STATION 663, RBL 42, UPPER STEM WALL PN HAS OIL CANNING. R & R OIL CANNING WEB MATERIAL. INSTALLED REPAIR WEB IAW SRM 57-10-10-2R PROCEDURE 3 ALT NR 2.SDR AALA20150826003Cargo Track · corrodedAFT CARGO COMPARTMENT RT TIE DOWN TRACK IS CORRODED AT STATION 794. INSTALLED REPAIR STRAP IAW EA 253912 DATED 8 25 2015.SDR AALA20150825012Angle · corrodedAFT CARGO COMPARTMENT RT TRANSITION ANGLE IS CORRODED BETWEEN STATIONS 767 & 787. R & R TRANSITION ANGLE SECTION IAW AARD 51-10-05-1.SDR AALA20150825007Floor Support · corrodedAFT CARGO COMPARTMENT CTR FLOOR STRINGER IS CORRODED AT STATION 727B. REPAIRED FLOOR STRINGER IAW EA 253779.SDR AALA20150824008Angle · corrodedAFT CARGO LT TRANSITION ANGLE IS CORRODED BETWEEN STATIONS 727 & 747. SPLICED IN REPLACEMENT TRANSITION ANGLE SECTION BETWEEN STATIONS 727F & 847 IAW SRM 53-00-53-2R.SDR AALA20150824003Support · wornLEFT LOWER FILLET SUPPORT FRAME AT STATION 727 AFT END OF WW AT KEEL BEAM AREA HAS DEEP WEAR. R & R THE T FRAME CAP FOR WING TO BODY SUPPORT AT STATION 727 LT SIDE IAW LAA AARD 51-00-05-1 REPAIR 1.SDR AALA20150824002Support · wornRIGHT LOWER FILLET SUPPORT FRAME AT STATION 727, AFT END OF WW AT KEEL BEAM AREA HAS DEEP WEAR. R & R THE T FRAME CAP FOR WING TO BODY SUPPORT AT STATION 727 RT SIDE IAW AARD 51-00-05-1 REPAIR 1.SDR AALA20150822008Door Sill · corrodedAFT CARGO COMPARTMENT LOWER DOOR PAN IS CORRODED BETWEEN STATIONS 794 & 847. R & R LOWER DOOR SILL WEB IAW AARD 51-10-05-1.SDR AALA20150822005Baffle · crackedFORWARD CARGO COMPARTMENT BAFFLE BELOW LT TRANSITION PANEL IS CRACKED AT STATION 500H, IN BAFFLE. R & R BAFFLE IAW DWG 143A7505 & SRM 53-30-53-0I-2.SDR AALA20150822004Angle · corrodedCORROSION ON TOP SURFACE OF LT TRANSITION ANGLE BETWEEN STATIONS 500G & 500I. INSTALLED NEW SECTION OF TRANSITION PANEL & SPLICES FROM STATION 500H TO 500H + 6" IAW SRM 53-00-53-2R-5.
Back to N912AN