N937AN
Service difficulty reports · 203
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 = 'N937AN' 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 = 'N937AN' 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 AALA20180328002Transition Panel · corrodedLEFT TRANSITION PANEL CORRODED FROM BS 460 - 500I. INSTALLED A NEW TRANSITION PANEL IAW SRM 51-00-05.SDR AALA20180328005Web · corrodedCORROSION FOUND ON THE AFT CABIN FLOOR WEB PAN LOCATED AT BS 1016 THRU 1024, RBL 28 THRU RBL 33. REPLACED CABIN FLOOR WEB IAW 51-00-05-1.SDR AALA20180327004Stiffener · corrodedCORROSION ON FOWARD SERVICE DOOR CENTER THRESHOLD SUPPORT, BS 304 TO 322. REPLACED THE SUPPORT ANGLE IAW AMM 20-60-07.SDR AALA20180325005Floorbeam · corrodedCORROSION WAS FOUND ON TOP OF FLOORBEAM AT BS 947.5 RBL 10 - 13. REPAIRED THE FLOORBEAM IAW SRM 53-00-51-2R-1, AND 53-00-00-7.SDR AALA20180323009Channel · corrodedCORROSION FOUND ON THE AFT CARGO LEFT TRANSITION PANEL CHANNEL BETWEEN BS 727H TO 727G. REPAIRED THE TRANSITION PANEL CHANNEL IAW SRM 53-00-53-2R, 51-00-05-1, AND DRAWING 146A7502.SDR AALA20180323005Bulkhead Web · crackedVERTICAL PRESSURE BULKHEAD WEB AT BS 663 HAS A CRACK BETWEEN RBL 40 TO RBL 45.6. REPAIRED BULKHEAD WEB IAW SRM 57-10-10-2R-3, ALT 2.SDR AALA20180322001Support · erodedLEFT MLG WW WING TO BODY FAIRING SUPPORT LANDING IS ERODED AT BS 663 TO 674, LBL 28. REPLACED THE SUPPORT IAW 51-00-05-1.SDR AALA20180322002Support · erodedRIGHT HAND MAIN LANDING GEAR WHEEL WELL WING TO BODY FAIRING SUPPORT LANDING IS ERODED BETWEEN BS 663 TO 674, RBL 28. REPLACED SUPPORT IAW 51-00-05-1.SDR AALA20180321002Rib · crackedRIGHT HORIZONTAL STABILIZER RIB AT HSS 92.7 HAS A CRACK IN THE 3RD RIB STIFFNER. FABRICATED, TREATED AND PRIMED REPAIR PARTS WITH CLEARANCE TO INSTALL IAW 55-10-09-2R-4.SDR AALA20180321005Stiffener · corrodedCORROSION ON APU INLET LOWER HORIZONITAL STIFFENER. REPLACED THE STIFFENER IAW 51-00-05-R1, AND DRAWING 148A8650.SDR AALA20180321004Stiffener · corrodedTHE AIRCRAFT IS IN BASE MAINTENANCE. CORROSION ON APU COMPARTMENT INLET VERTICAL STIFFENER AT STATION 1125. REPLACED STIFFENER PER 51-00-05-R1 AND DRAWING 14848650.SDR AALA20180320005Angle · corrodedCORROSION ON THE ANGLE, BS 767, STRINGER 25R. INSTALLED A NEW ANGLE IAW DRAWING 146A0081, AND 51-00-05.SDR AALA20180320006Angle · corrodedCORROSION AROUND A NUTPLATE ON THE RIGHT ZEE ANGLE AT BS 869. REMOVED CORROSION AND INSTALLED A NEW ANGLE SRM 53-00-53-2R, 51-00-05-1, AND DWG 146A7502.SDR AALA20180320004Transition Panel · corrodedCORROSION ON THE AFT CARGO BAY RIGHT TRANSITION PANEL AT BS 777. REPLACED THE TRANSITION PANEL IAW DRAWING 146A0081, AND 51-00-05.SDR AALA20180315004Floor Support · crackedCABIN FLOOR SUPPORT CRACKED BETWEEN BS 312 - 328, RBL 31. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1.SDR AALA20180315003Floor Support · crackedCABIN FLOOR SUPPORT CRACKED BETWEEN BS 328 - 344, LBL 45. REPLACED THE FLOOR SUPPORT 51-00-05-1.SDR AALA20180315002Floor Support · crackedCABIN FLOOR SUPPORT BETWEEN BS 312 - 328, LBL 45 FOUND CRACKED. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1.SDR AALA20180315001Floor Support · crackedCABIN FLOOR SUPPORT BETWEEN BS 292 - 277, BL 0 IS CRACKED. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1.SDR AALA20180312004Fitting · corrodedCABIN FLOOR GIRT BAR FITTING CORRODED OUT OF LIMITS. REPLACED THE GIRT BAR FITTING IAW 51-00-05-1.SDR AALA20180312003Fitting · corrodedCABIN FLOOR GIRT BAR FITTING AT BS 312, LBL 54 CORRODED OUT OF LIMITS. REPLACED THE GIRT BAR FITTING IAW 51-00-05-1.SDR AALA201802089002Smoke Detector · false activationTHREE MINUTES PRIOR TO LANDING, A LAVATORY SMOKE LIGHT ILLUMINATED. VERIFIED NO ISSUE IN LAVATORY. ACCOMPLISHED FIM 26-14-00. LAVATORY AFT RIGHT SMOKE DETECTOR RESET. LIGHT EXTINGUISHED.SDR AALA201801109013Bracket · crackedRIGHT AFT SERVICE DOOR EXIT SIGN BRACKET IS CRACKED. SECURED SIGN LENS. REPLACED LIGHT ASSY IAW AMM 33-51-00.SDR AALA201710279034Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE L2 DOOR HAS A DETACHED LENS COVER. REMOVED AND REPLACED EXIT SIGN LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170725004Battery Pack · dischargedEMER EXIT LIGHTS AT 5EF, 7DEF, AND 9ABC INOPERATIVE. REMOVED & REPLACED THE EMERGENCY LIGHT ASSYS. REMOVED AND REPLACED THE BATTERY PACKS. PERFORMED AN OPS CHECK OF THE SYSTEM, CHECKED GOOD IAW MM 33-51-00. THE AIRCRAFT WAS GROUNDED.SDR AALA201707259005Light · inoperativeTHE AIRCRAFT WAS GROUNDED. EMERGENCY LIGHTS ON BULL NOSE BAG BINS INOP AT SEATS 5EF, 7DEF, AND 9ABC. R&R POWER SUPPLY ASSY AT M1674 (NO HELP). R&R LIGHT ASSYS AT 5EF, 7DEF, & 9AB. PERFORMED OPS CK EMER LIGHT SYS IAW MM 33-51-03, OPS NML. AC OK FOR CONT SVSDR AALA201706059071Cover · looseAFT LEFT SIDE EXIT LIGHT COVER LOOSE. REPLACED AFT LEFT EXIT LIGHT ASSY IAW 33-51-01 - OPS GOOD - OK FOR SERVICE.SDR AALA20170206016Smoke Detector · false indicationRIGHT AFT LAVATORY SMOKE DETECTOR TRANSMITTED AUDIO ALERTS INTERMITTENTLY FOR NO APPARENT REASON. REMOVED AND REPLACED THE SMOKE DETECTOR IAW AMM 26-14-01. OP CHECKED GOOD.SDR AALA20170202018Warning System · false activationAIRCRAFT WAS GROUNDED. EMERGENCY WAS DECLARED. DURING CRUISE THE ANTI-SKID INOPERATIVE LIGHT ILLUMINATED. MAINTENANCE CYCLED POWER TO AACU AND ACCOMPLISHED FIN TASK 32-42-00-810-801. SYSTEM CHECKS NORMAL.SDR AALA20170105011Lens · missingAIRCRAFT NOT GROUNDED. EMERGENCY EXIT SIGN IN AISLE FORWARD CLOSET AREA FLOOR LEVEL IS MISSING LENS COVER. REMOVED AND REPLACED EXIT SIGN ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD. (CLOSED)SDR AALA20160621012Pressure Panel · crackedAIRCRAFT WAS IN BASE MAINTENANCE. CENTER WING REAR SPAR VERTICAL PRESSURE WEB AT FUSELAGE STA 663.75 IS CRACKED BETWEEN LBL 40 AND LBL 45.6 AND BETWEEN RBL 40 AND RBL 45.6. REPAIRED WEB IAW EA 261275 AND EA 261273.SDR AALA20160617005Intercostal · crackedAIRCRAFT WAS IN BASE MAINTENANCE. INTERCOSTAL AT LBL 48 BETWEEN FUSELAGE STA 312 AND STA 328 IS CRACKED. R & R INTERCOSTAL IAW AARD 51-10-05-1.SDR AALA20151231003Skin · crackedRIGHT HORIZONTAL STABILIZER LOWER SKIN HAS CRACKS AT STATION 129.5. INSTALLED REPAIR IAW SRM 55-10-01-2R. ACFT IN BASE MX.SDR AALA20151005007Receptacle · faultySMOKE & FUMES REPORTED IN CABIN DURING FLIGHT, STRONGEST IN THE AFT CABIN, BUT FOUND THROUGHOUT. SMOKE SEEMED TO DISSIPATE WITH IFE POWER REMOVED. AN EMER WAS DECLARED & THE FLIGHT DIVERTED WITHOUT FURTHER INCIDENT. ACFT REMOVED FROM SERVICE. FAULT CONFIRMSDR AALA20150327006Access Door · openAIR INTERRUPT, DIVERTED, EMER NOT DECLARED. LANDING UNEVENTFUL & ACFT NOT OVERWEIGHT. DURING CLIMB CREW NOTED A LOUD VIBRATION. MX OBSERVED EXTERNAL POWER DOOR TO BE OPEN. INSPECTED FOR DAMAGE & CLOSED & LATCHED DOOR. SYS CHECKED NORMAL.SDR AALA20150210022Shim · missingDURING GOGO INSTALLATION IT WAS FOUND THAT THE RADIUS BLOCK SPACERS SHOWN IN DWG P19112-21606 REV D1 SHEET 11 VIEW L L UNDER THE EXISTING C CHANNEL, AT THE FASTENER 130 LOCATIONS ARE NOT PRESENT ON THIS ACFT. FABRICATED & INSTALLED RADIUS BLOCKS IAW EA 53-038SDR AALA20150129009Seat Track · crackedCABIN SEAT TRACK AT FS 727B & LBL 24.75 IS CRACKED ON ITS INBD & OTBD FLANGES JUST FWD OF SPLICE. REPAIRED SEAT TRACK IAW EA 53-038398 DATED 02 FEB 2015.SDR AALA20150129008Seat Track · crackedCABIN SEAT TRACK AT FS 727B & RBL 24.75 IS CRACKED ON ITS INBD & OTBD FLANGES JUST FWD OF SPLICE. REPAIRED SEAT TRACK IAW EA 53-038398 DATED 02 FEB 2015.SDR AALA20150129007Seat Track · crackedCABIN SEAT TRACK AT FS 727B & RBL 45.50 IS CRACKED ON ITS INBD & OTBD FLANGES JUST FWD OF SPLICE. REPAIRED SEAT TRACK EA.SDR AALA20150129006Seat Track · crackedCABIN SEAT TRACK AT FS 727B & LBL 45.50 IS CRACKED ON ITS INBD & OTBD FLANGES JUST FWD OF SPLICE. REPAIRED SEAT TRACK ENGINEERING AUTHORIZATION.SDR AALA20140929013Lens · missingEMERGENCY LIGHT AT SEAT 14D MISSING RED LENS. REPLACED RED LENS FOR EMER LIGHT AT SEAT 14D. OPERATIONS CHECKED NORMAL.SDR AALA20140925003Light · missingEMERGENCY LIGHT AT SEAT 14D MISSING LAMPS. REPLACED LAMPS FOR EMER LIGHT AT SEAT 14D. OPERATIONS CHECKED NORMAL.SDR AALA20140715007Skin · dentedFUSELAGE SKIN DENTS BETWEEN STATIONS 807 & 847 FROM STRINGERS 26 LT TO 25 RT. INSTALLED DOUBLER REPAIR IAW EA B737-53-035739.SDR AALA20140417005Battery Pack · dischargedEMERGENCY LIGHTS ABOVE SEATS 28ABC TO 30ABC INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS ABOVE SEATS 28ABC TO 30ABC. OPERATIONS CHECKED NORMAL.SDR AALA20140417004Battery Pack · dischargedRIGHT OVERWING EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED BATTERY PACK FOR OVERWING EMERGENCY EXIT LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20140417001Battery Pack · dischargedMOUNTED EMERGENCY LIGHTS FROM SEATS 14DEF TO 22DEF INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS FROM SEATS 14DEF TO 22DEF. OPERATIONS CHECKED NORMAL.SDR AALA20130909008Light · inoperativeLT AFT EXTERIOR OVERWING EMERGENCY LIGHT INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR LT AFT EXTERIOR OVERWING EMERGENCY LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130204004Lens · missingEMERGENCY EXIT SIGN OVER FORWARD SERVICE DOOR IS MISSING LENS COVER. REPLACED EXIT SIGN LENS COVER. OPS CHECK NORMAL.SDR AALA20120913002Battery Pack · dischargedLEFT AFT OVERWING EXTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED BATTERY PACK FOR LEFT AFT OVERWING EXTERIOR EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20120704011Connector · corrodedBNA - CREW REPORTED WHEN SELECTING FLAPS FOR LANDING FLAPS WOULD NOT COME OUT OF UP POSITON. EMERGENCY DECLARED FLIGHT LANDED BNA WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND NUMBER 3 FLAP ASKEW SENSOR ELECTRONIC CONNECTOR CORRODED. REPLACED CONNSDR AALA20120626009Pushrod · bentPHL - PILOT REPORTED FLAPS JAMMED IN UP POSITION. EMERGENCY DECLARED FLIGHT LANDED PHL WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED RIGHT INBOARD TRAILING EDGE AFT FLAP INBOARD AND OUTBOARD FLAP PUSHRODS AND RIGHT INBOARD AFT FLAP DRIVE ROD THAT
Back to N937AN