N936AN
Service difficulty reports · 208
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 = 'N936AN' 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 = 'N936AN' 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 AALA20180228003Angle · corrodedR2 CREASE ANGLE HAS CORROSION BETWEEN BS 887 TO 1016. REPLACED THE CREASE ANGLE IAW 51-00-05-1 AND DRAWING 147A8501.SDR AALA20180226015Channel · corrodedCORRODED LEFT TRANSITION PANEL CHANNEL BETWEEN BS 807 TO 827. REPLACED THE CHANNEL IAW SRM 53-00-53-2R AND EA.B737-53-022404.SDR AALA20180226003Strap · corrodedCORRODED STRAP AT BS 1019 AND RBL 27 STRAP AT BS 1019. REPLACED STRAP IAW DRAWING 147A5700 AND 51-00-05-1.SDR AALA20180226016Angle · wornAIRCRAFT WAS IN BASE MAINTENANCE. FLOORBOARD Z ANGLE HAS DEEP WORN SPOT AT STA 510 LBL 6. REPAIRED Z ANGLE PER SRM 53-00-53-2R-2.SDR AALA20180226004Strap · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. STRAP IS CORRODED AT STA 1030, AND RBL 18. REPLACED STRAP PER DRAWING 147A5700 AND AARD 51-00-05-1.SDR AALA20180226014Transition Panel · corrodedTHE AIRCRAFT IS IN BASE MAINTENANCE. CORROSION ON RIGHT HAND TRANSITION PANEL AT STATIONS 727A-727B. REPLACED TRANSITION PANEL PER SRM 53-00-53 AND 51-00-05-1.SDR AALA20180226005Threshold · corrodedTHE AIRCRAFT IS IN BASE MAINTENANCE. CORROSION ON R2 DOOR THRESHOLD WEB. REPLACED WEB PER 51-00-05-1, DRAWING 147A8510 AND EA 277849.SDR AALA20180228002Strap · corrodedCORROSION ON STRAP AT BS 1030 AND RBL 3. REPLACED STRAP IAW DRAWING 147A5700 AND 51-00-05-1.SDR AALA20180228001Intercostal · corrodedINTERCOSTAL AT BS 991, LBL 32 HAS CORROSION ON UPPER SURFACE. REPLACED INTERCOSTAL IAW SRM 51-10-02, AND DRAWING 147A5705.SDR AALA20180225010Channel · corrodedLEFT HAND TRANSITION PANEL CHANNEL CORRODED BETWEEN BS 400 AND 500L. REPLACED THE CHANNEL IAW SRM 53-00-53-2R-5.SDR AALA20180225008Baffle · corrodedBAFFLE AT BS 460-480, LBL 25 HAS CORROSION. REPLACED THE BAFFLE IAW DRAWING 143A7505, AND 51-00-05-01.SDR AALA20180225007Baffle · corrodedBAFFLE BETWEEN BS 500C - 500D UNDER TRANSITION PANEL HAS CORROSION. REPLACED THE BAFFLE IAW 51-00-05-1, AND DRAWING 143A750.SDR AALA20180221007Shield · corrodedCORRODED AFT CARGO SHIELD FORWARD OF DOOR OPENING. REPLACED THE SHIELD IAW DRAWING 146A8127, AND 51-00-05-1.SDR AALA20180221006Shield · corrodedCORRODED AFT CARGO SHIELD, BS 847. REPLACED THE SHIELD IAW DRAWING 146A0081 AND 51-00-05-1.SDR AALA20180221003Floorbeam · corrodedCORRODED FLOORBEAM TEE AT BS 985, LBL 4 TO LBL 51. REPAIRED THE FLOORBEAM IAW SRM 51-10-02, AND EA 277694SDR AALA20180225003Intercostal · corrodedTHE FORWARD CARGO ON THE RIGHT SIDE, THERE WAS CORROSION ON THE UPPER FLANGE OF THE INTERCOSTAL BETWEEN BS 500F-500G. REPAIRED THE INTERCOSTAL IAW SRM 51-70-13-2R-1, SRM 53-30-53-01, AND DRAWING 143A7510.SDR AALA20180226008Doubler · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CORROSION FOUND ON INTER-SKIN ANTENNA DOUBLER BETWEEN STA 500 -500-A AND BETWEEN STR 28L -28R. REPLACED INTER-SKIN ANTENNA DOUBLER PER 51-00-05 AND DRAWING NUMBER 143A3230.SDR AALA20180225002Transition Panel · corrodedRIGHT TRANSITION PANEL FROM 500A-500L HAS NUMEROUS AREAS OF CORROSION. REPLACED THE TRANSTIION PANEL IAW SRM 53-00-53-2R-5.SDR AALA20180224004Angle · corrodedSHORT TRANSITION PANEL ANGLE BETWEEN BS 495 - 500A RIGHT CORRODED. REPLACED THE ANGLE IAW SRM 51-40-02.SDR AALA20180224003Angle · corrodedSHORT TRANSITION PANEL ANGLE BETWEEN BS 420 - 440 RIGHT HAS CORROSION. REPLACED TRANSITION ANGLE IAW SRM 51-40-02.SDR AALA20180303006Web · corrodedCORRODED WEB AT BS 984, RBL 33 TO RBL 41. REPLACED THE WEB IAW DRAWING 147A5700, AND 51-00-05-1.SDR AALA20180303004Floor Support · corrodedCORROSION ON THE NUT PLATE HOLE OF THE FLOOR SUPPORT IN FORWARD SERVICE WET AREA AT BS 325, RBL 11. REPLACED FLOOR SUPPORT IAW 51-00-05-1, AND DRAWING 141A5400.SDR AALA20180303003Angle · corrodedCORROSION FOUND ON THE AFT BULKHEAD TRANS ANGEL AT BS 500I. INSTALLED NEW TRANS ANGLE AND FASTENERS IAW 51-00-05-1, AND DWG:143A9485.SDR AALA201711229022Unknown · odorAIRCRAFT WAS NOT GROUNDED. NAUSEOUS DIRTY SOCKS ODOR IN CABIN WHEN THE RIGHT PACK IS TURNED TO AUTO. CHECKED RECIRCULATION FILTERS, LEFT/RIGHT ENGINE INLETS AND APU PLENUM FOR CONTAMINATION. NONE NOTED. ACCOMPLISHED PACK 2 OPERATIONAL CHECK PER AMM 21-51-0SDR AALA20171018007Power Supply · failedAIRCRAFT WAS GROUNDED. ON TAXI IN, FLIGHT ATTENDANT REPORTED THE CEILING EMERGENCY EXIT LIGHTS AT THE AFT GALLEY ILLUMINATED. REMOVED AND REPLACED POWER SUPPLY PER AMM 33-51-06. OPERATIONAL CHECK GOOD.SDR AALA201709089023Smoke Detector · false activationAIRCRAFT WAS NOT GROUNDED. AFT LEFT LAVATORY SMOKE DETECTOR ANNUNCIATOR AND ALARM ON. FLIGHT ATTENDANT REPORTS VICINITY OF TRASH CAN FEELS WARM. RESET SMOKE DETECTOR PER AMM 26-14-00. OPERATIONAL CHECK GOOD.SDR AALA20170506003Bulkhead Web · crackedLEFT MAIN LANDING GEAR WHEEL WELL VERTICAL PRESSURE DECK WEB CRACKED AT BS 663.75, LBL31.83 TO LBL43.80. REPAIRED IAW SRM 57-10-10-2R-3 ALTERNATIVE 2.SDR AALA20170506002Web · crackedCENTER WING REAR SPAR RIGHT MAIN LANDING GEAR WHEEL WELL VERTICAL PRESSURE DECK WEB CRACKED AT FUSELAGE STATION 663.75, RBL31.83 TO RBL43.80. REPAIRED IAW SRM 57-10-10-2R-3 ALTERNATIVE 2.SDR AALA20161229012Light · brokenAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT L1187 AT L1 DOOR IS BROKEN. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20161229011Light · brokenAIRCRAFT NOT GROUNDED. EMERGENCY EXIT LIGHT L1191 AT R2 DOOR IS BROKEN. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20160605004Warning System · false activationAIRCRAFT WAS GNDED. DURING TAKEOFF THE TAKEOFF CONFIGURATION WARNING LIGHT ILLUMINATED. TAKEOFF WAS ABORTED AT APPROX 105 KNOTS. ACCOMPLISHED FIM 31-51-00-810-803 & 31-51-00-810-822 WITH SATISFACTORY RESULTS.SDR AALA20160423006Pressure Panel · crackedAIRCRAFT WAS IN BASE MX. VERTICAL PRESS WEB AT FS 663.75 IS CRACKED AT APPROX RBL 44. REPAIRED WEB IAW EA 259851.SDR AALA20160425003Fitting · crackedAIRCRAFT WAS IN BASE MX. RAM AIR INLET FWD FAIRING ANGLE CLIP HAS A 0.5 INCH CRACK AT OTBD LOWER END. R & R ANGLE CLIP IAW DWG 143A0060 ID 0022 & SRM 51-10-02-0G PARAGRAPH 9.SDR AALA20160314008Post · crackedCRACK FOUND IN FIRST OFFICERS NR 3 WINDOW POST FASTENER HOLE, SECOND HOLE FROM BOTTOM. INSTALLED DOUBLER & TRIPLER REPAIR IAW ESO 61000 & AARD 53-10-00-7. ACFT IN BASE MX.SDR AALA20150828001Skin · corrodedFUSELAGE SKIN IS CORRODED AROUND AFT LAVATORY VENT AT STATION 907 & STRINGER 23L. ACCOMPLISHED DOUBLER REPAIR IAW EA 253938.SDR AALA20150828003Bulkhead · crackedLEFT MAIN WW FWD BULKHEAD WEB AT STATION 663.75 IS CRACKED BETWEEN LBL 31.83 & LBL 43.80. REPAIRED WEB IAW EA 253963.SDR AALA20150828002Bulkhead · crackedRIGHT MAIN WW FWD BULKHEAD WEB AT STATION 663.75 IS CRACKED BETWEEN RBL 31.83 & RBL 43.80. REPAIRED WEB IAW EA 253963.SDR AALA20150420007Power Supply · dischargedSEAT ROWS 12D - 22D & 14DC OVERHEAD LIGHTING FAILED TO ILLUMINATE. SEAT LIGHTING BETWEEN ROW 13 - 20 FAILED CAPACITY CHECK. R & R FWD POWER SUPPLY IAW AMM 33-51-06.SDR AALA20150417014Power Supply · dischargedSEAT ROWS 12D - 22D & 14DC OVERHEAD LIGHTING FAILED TO ILLUMINATE. SEAT LIGHTING BETWEEN ROW 13 - 20 FAILED CAPACITY CHECK. R & R AFT POWER SUPPLY IAW AMM 33-51-06.SDR AALA20150120008Hinge · crackedAIR INTERRUPT, DIVERTED, EMER NOT DECLARED. LANDING UNEVENTFUL & ACFT NOT OVERWEIGHT. DURING CLIMB AIRFRAME VIBRATION WAS NOTED ABOVE 250 KNOTS. UPON ARRIVAL, EXTERNAL POWER ACCESS DOOR WAS FOUND OPEN WITH HINGE CRACKED. HINGE TRIMMED & DOOR SECURED WITH SSDR AALA20150112009Light · inoperativeEMERGENCY DECLARED, LANDING UNEVENTFUL & ACFT NOT OVERWEIGHT. DURING APPROACH PLACED LANDING GEAR LEVEL DOWN & RT MAIN GEAR GREEN LIGHT WAS NOT ILLUMINATED. REPLACED 2 LIGHT BULBS & RT GEAR GREEN LIGHT ILLUMINATED. GREEN INDICATOR LIGHTS FOR GEAR ALL NORMALSDR AALA20140422007Skin · scratchedWHEN PAINTERS REMOVED THE N DECAL THEY NOTED A DEEP SCRATCH HIDDEN UNDER THE DECAL AT STATION 917. INSTALLED DOUBLER REPAIR IAW SRM 53-00-01-2R-3.SDR AALA20130924002Skin · corrodedLIGHT CORROSION AROUND AFT LAVATORY VENT FROM BS 928 TO 930. INSTALLED DOUBLER.SDR AALA20130923020Skin · corrodedCORROSION ON SKIN AT BS 928 BETWEEN LONGERONS 22 & 21 LT. INSTALLED DOUBLER.SDR AALA20130923019Skin · corrodedCORROSION ON FS SKIN AT BS 928 BETWEEN LONGERONS 22 & 23 LT. INSTALLED DOUBLER.SDR AALA20130916001Solenoid · inoperativeTUL CREW REPORTED RT AFT OVERWING EMERGENCY EXIT DOOR LIGHT ILLUMINATED DURING DESCENT. FLIGHT LANDED TUL LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED RT FLIGHT LOCK SOLENOID ON THE RT AFT OVERWING EMERGENCY EXIT DOOR. SYSTEM GROUND CHESDR AALA20130329004Seat Track · crackedSEAT TRACK AT LEFT BUTTLINE 24.75 OUTBOARD AFT HOLE HAS CRACK INDICATION. REPAIRED SEAT TRACK PER EA B737-53-028811.SDR AALA20130329003Seat Track · crackedSEAT TRACK AT STATION 727B LEFT BUTTLINE 24.75 OUTBOARD FORWARD HOLE HAS CRACK INDICATION. REPAIRED SEAT TRACK PER EA B737-53-028811.SDR AALA20130329002Seat Track · crackedSEAT TRACK AT LEFT BUTTLINE 24.75 INBOARD AFT HOLE HAS CRACK INDICATION. REPAIRED SEAT TRACK PER EA B737-53-028811.SDR AALA20130315008Seat Track · crackedSEAT TRACK AT LEFT BUTTLINE 24.75 INBOARD FORWARD HOLE HAS CRACK INDICATION. REPAIRED SEAT TRACK PER EA B737-53-028811.
Back to N936AN