N938AN
Service difficulty reports · 222
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 = 'N938AN' 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 = 'N938AN' 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 AALA20180129011Floor Support · corrodedTHE AIRCRAFT IS IN BASE MAINTENANCE. AFT CABIN FLOOR SUPPORT CORRODED OUT OF LIMITS BETWEEN STATIONS 947-967 RBL 52. INSTALLED NEW FLOOR SUPPORT PER AARD 51-00-05-1.SDR AALA20180129007Intercostal · elongatedTHE AIRCRAFT WAS IN BASE MAINTENANCE. AFT CABIN FLOOR INTERCOSTAL BETWEEN STATION 927-947 RBL 25, SEVERAL ATTACH HOLES ELONGATED OUT OF LIMITS. INSTALLED NEW SERVICEABLE INTERCOSTAL PER 51-00-05-1 AND DRAWING 147A5760 AND EA 276927 DRAFT 1.SDR AALA20180129012Support · corrodedCORRODED LEFT AFT DECK WALL SUPPORT AT BS 994, LBL 33 TO LBL 46. REPLACED DECK WALL SUPPORT ZEE ANGLE IAW 51-00-05-1, DRAWINGS 147A5710, AND 147A5700.SDR AALA20180129010Angle · corrodedCORRODED L2 DOOR SILL ANGLE BETWEEN BS 900 TO 1006. REPLACED THE ANGLE IAW 51-00-05-1, REPAIR 1.SDR AALA20180125005Angle · corrodedCORRODED RIGHT CREASE ANGLE BETWEEN BS 900 TO 1006, RBL 56. REPLACED THE CREASE ANGLE IAW 51-00-05-1, REPAIR 1.SDR AALA20180125003Angle · corrodedCORRODED ZEE ANGLE, 6 INCHES AFT OF THE BS 987, RBL 42. REPLACED THE ANGLE IAW DRAWINGS 147A5710, AND 147A5700, 51-00-05-1, AND SRM 51-40-02.SDR AALA20180119006Web · corrodedAFT CARGO DOOR WEB HAS CORROSION FROM BS 795 - 847. REPLACED AFT CARGO DOOR WEB IAW DWG 146A81230, AND 51-00-05.SDR AALA20180119005Transition Panel · corrodedLIGHT CORROSION FOUND ON TRANSITION PANEL AT BS 787, AROUND SCREW HOLES. INSTALLED A NEW TRANSITION PANEL IAW 51-00-05-1A, AND SRM 53-00-53-2R.SDR AALA20180118004Bear Strap · corrodedCORROSION AT AFT CARGO BEAR STRAP FOR INNER DOOR CUT OUT, FORWARD LOWER CORNER AT BS 798. INSTALLED A REPAIR DOUBLER AND FILLER IAW EA 274683.SDR AALA20180118007Cargo Track · corrodedCORROSION ON AFT CARGO BAY, CARGO TRACK, RBL 13.8, BS 787 - 847. REPLACED THE CARGO TRACK IAW SRM 51-10-02, BOEING DRAWING 146A7501, AND 51-00-05.SDR AALA20180118009Floorbeam · corrodedFLOORBEAM AT BS 987, APPROXIMATELY LBL 18 AND LBL 21, HAS CORROSION ON THE UNDERSIDE OF THE AFT LEG OF TOP FLANGE AROUND FLOORBOARD HOLES. REMOVED CORROSION IAW SRM 51-10-02. FABRICATED AND DRILLED ALL REPAIR PARTS, DEBURRED, ALODINED AND PRIMED ALL PARTS IASDR AALA20180118002Floorbeam · corrodedCORROSION ON AFT CABIN FLOORBEAM UPPER TEE CAP AT BS 987, RBL 48. REPAIRED THE FLOOR BEAM TEE IAW EA 276504, AND SRM 53-00-51-R1.SDR AALA20180118001Floorbeam · corrodedCORROSION ON THE FLOORBEAM, BS 987, LBL 43. REPLACED THE REPAIR FILLER IAW EA B737-53-022852, AND SRM 53-00-51-R1.SDR AALA20180115014Transition Panel · corrodedCORROSION ON RIGHT TRANSITION PANEL AT BS 767 - 787. INSTALLED A NEW TRANSITION PANEL IAW DRAWING 146A0081 AND 51-00-05-1.SDR AALA20180115011Pan · corrodedCORROSION ON DECK AROUND LEFT AFT GALLEY MOUNT PAN AT BS 1016, LBL 33. REPLACED THE PAN ASSEMBLY IAW 51-00-05-1 AND DRAWING 147A5712.SDR AALA20180112013Angle · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION ON RIGHT TRANSITION PANEL ANGLE BETWEEN BS 727N PLUS 10 INCHES TO BS 767. REPLACED THETRANSITION PANEL ANGLE IAW 51-00-05-1A, SRM 53-00-53-2R-5, AND DRAWING 146A7502.SDR AALA20180111006Intercostal · corrodedCORROSION ON E&E BAY INTERCOSTAL WEB BETWEEN BS 312 TO 325 AT STRINGER 23L. REPLACED THE INTERCOSTAL IAW 51-00-05 AND 141A8131.SDR AALA20180108006Stiffener · corrodedCORROSION ON VERTICAL STIFFENER IN APU COMPARTMENT OF RIGHT SIDE AT BS 1125. INSTALLED VERTICAL STIFFENER IAW DRAWING148A8650 AND 51-00-05-R1.SDR AALA20180105008Angle · corrodedCORROSION ON THE RIGHT TRANSITION PANEL ANGLE FROM BS 847 TO 867. REPLACED THE ANGLE IAW DRAWING 146A0081 AND 51-00-05-1.SDR AALA20180104001Transition Panel · corrodedCORROSION ON LEFT TRANSITION PANEL BETWEEN BS 500D TO 500E. REPLACED THE TRANSIITON PANEL IAW SRM 53-00-53-2R-5.SDR AALA20171222003Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE. CRACKED RIGHT HAND CENTER AISLE FLOOR BOARD SUPPORT AT STA 540. REPLACED RIGHT HAND CENTER AISLE FLOOR BOARD SUPPORT AT STA 540 PER 51-00-05 AND IPC DRAWING 53-31-00-05.SDR AALA20171222002Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE. CRACKED LEFT HAND CENTER AISLE FLOOR BOARD SUPPORT AT STA 540. REPLACED LEFT HAND CENTER AISLE FLOOR BOARD SUPPORT AT STA 540 PER AARD 51-00-05 AND IPC DRAWING 53-31-00-05.SDR AALA20171222001Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE. CRACKED INTERCOSTAL BETWEEN STA 312 TO STA 328 AT LEFT BUTTLINE 45. REPLACED INTERCOSTAL BETWEEN STA 312 TO STA 328 AT LEFT BUTTLINE 45 PER DRAWING 141A5400 AND 51-00-05-1.SDR AALA20171003001Light · brokenEMERGENCY EXIT LIGHT BY THE R2 DOOR IS BROKEN. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-01. OPS CHECKED GOOD. AIRCRAFT WAS GROUNDED.SDR AALA20170923002Sensor · faultyAIRCRAFT WAS GROUNDED. AFTER TAKEOFF WITH THE GEAR HANDLE IN UP POSITION , BOTH RED AND GREEN NOSE LANDING GEAR LIGHTS ILLUMINATED. ACCOMPLISHED QRH PROCEDURES AND ALL THREE GEAR NORMAL ON RETURN LANDING TO MIA. REMOVED AND REPLACED NOSE LANDING GEAR DOWN PSDR AALA201709159002Light · brokenEMERGENCY EXIT LIGHT BY THE L2 DOOR IS BROKEN. REMOVED AND REPLACED THE LIGHT ASSEMBLY IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA201708149048Power Supply · malfunctionedTHE AIRCRAFT WAS NOT GROUNDED. F/A NOTIFIED US THAT IFE SYSTEM SHUTDOWN ON ITS OWN IN FLIGHT. THEY TURNED SYSTEM OFF AND WE TURNED IFE/PASS SEAT SWITCH OFF. THEY RESTARTED SYSTEM. F/A NOTIFIED US OF AN ELECTRICAL SMELL ROW 17 AND AFT. THE STRONGEST SMELL SDR AALA201708119021Gust Lock · looseTHE AIRCRAFT WAS NOT GROUNDED. 1L DOOR GUST LOCK SWITCH WILL NOT STAY IN UNLOCKED POSITION WHEN PRESSED. MUST BE HELD DOWN UNTIL DOOR IS ALMOST CLOSED. TIGHTENED HOLD OPEN LOCK AT L1 DOOR IAW AMM 52-11-00. OPS CHECK NORMAL.SDR AALA201706099040Light · brokenTHE AIRCRAFT WAS NOT GROUNDED. EXIT LIGHT COVER AT AFT LEFT EXIT WILL NOT STAY IN PLACE. FOUND LIGHT ASSY BROKEN. REMOVED AND REPLACED AFT LT EXIT LIGHT ASSY REF MM 33-51-01. OPS CHECK NORMAL. OK FOR SERVICE.SDR AALA201704259035Light · damagedEMERGENCY LIGHT NEXT TO FORWARD SERVICE DOOR DAMAGED. REMOVED AND REPLACED THE EMERGENCY LIGHT BASE & LIGHT TESTED GOOD IAW AMM 33-51-01.SDR AALA20161226002Downlock Sensor · faultyRIGHT MAIN LANDING GEAR INDICATION LIGHT BEGAN FLICKERING. EMERGENCY DECLARED, RETURNED TO DEPARTURE, LANDING UNEVENTFUL, AND AIRCRAFT WAS GROUNDED. PSEU LIGHT ILLUMINATED AFTER LANDING AND WOULD NOT RESET. REMOVED AND REPLACED THE RIGHT MLG DOWN-AND-LOCKSDR AALA20161003005Connector · damagedEMERGENCY DECLARED. LANDING UNEVENTFUL. DURING APPROACH TRAILING EDGE FLAPS FAIL TO EXTEND WHEN SELECTED. FLAPS LOCKED OUT AT 1 DEGREE. MAINTENANCE REMOVED AND REPLACED SKEW SENSOR NR 1 IAW AMM 27-59-01 AND CONNECTOR D400024P IAW AMM 20-61-11. OPERATIONAL CHECSDR AALA20160930007Sensor · faultyEMERGENCY DECLARED. LANDING UNEVENTFUL. DURING APPROACH TRAILING EDGE FLAPS FAIL TO EXTEND WHEN SELECTED. FLAPS LOCKED OUT AT 1 DEGREE. MAINTENANCE REMOVED AND REPLACED SKEW SENSOR #1 IAW AMM 27-59-01 AND CONNECTOR D400024P IAW AMM 20-61-11. OPERATIONAL CHECK SDR AALA20160927009Indicator · false indicationDURING APPROACH, THE RIGHT FLAP INDICATOR SHOWED 1/3 WIDTH BETWEEN UP AND 1 DEGREE. LEFT INDICATOR SHOWED FULL UP. EMERGENCY DECLARED. AIRCRAFT WAS GROUNDED. MAINTENANCE ACCOMPLISHED FLAP INDICATION TEST IAW AMM 27-58-02 WITH NO FAULTS FOUND. PERFORMED PSESDR AALA20160925003Sensor · faultyDURING CLIMB THE NR 7 LEADING EDGE SLAT DID NOT RETRACT AND THE LEADING EDGE FLAPS TRANSIT LIGHT ILLUMINATED. MAINTENANCE REMOVED AND REPLACED THE NR 7 SLAT SENSOR AND ACCOMPLISHED TEST IAW AMM 27-88-11. SYSTEM CHECKED NORMAL.SDR AALA20160701001Acm · smokeDURING CRUISE CREW REPORTED SMOKE AND FUMES IN COCKPIT WITH SUPPLY DUCT TEMPERATURE RISE TO 140 DEGREES. LEFT PACK LIGHT ILLUMINATED AFTER LANDING. EMERGENCY DECLARED. LANDING UNEVENRTFUL, AND AIRCRAFT WAS GROUNDED. REMOVED & REPLACED THE LT ACM. OPS CHECKEDSDR AALA20160627010Intercostal · crackedAIRCRAFT WAS IN BASE MAINTENANCE. FLOOR SUPPORT INTERCOSTAL BETWEEN FUSELAGE STA 312 AND 328 UNDER THE FORWARD ENTRY IS CRACKED. R & R INTERCOSTAL IAW AARD 51-00-05-1 AND SRM 51-10-02.SDR AALA20160626009Intercostal · crackedAIRCRAFT WAS IN BASE MAINTENANCE. FLOOR SUPPORT INTERCOSTAL BETWEEN FUSELAGE STA 328 AND 344 UNDER THE FORWARD ENTRY IS CRACKED. R & R INTERCOSTAL IAW AARD 51-00-05-1 AND SRM 51-10-02.SDR AALA20160627012Angle · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. AFT CARGO COMPARTMENT LT TRANSITION ANGLE BETWEEN FUSELAGE STA 760 AND STA 816 IS CORRODED. REPAIRED TRANSITION ANGLE IAW SRM 53-00-53-2R.SDR AALA20160601003Skin · crackedLT HORIZONTAL STABILIZER LOWER SKIN IS CRACKED AT APPROX STABILIZER STATION 129.50. REPAIRED SKIN IAW SRM 55-10-01-2R-11.SDR AALA20160502010Sensor · out of limitsAIRCRAFT WAS GNDED. EMER DECLARED, LANDING UNEVENTFUL & ACFT NOT OVERWEIGHT. DURING CLIMB, WHEN FLAPS SET TO 5 THE NR 3 LE IN TRANSIT LIGHT ILLUMINATED, THEN EXTINGUISHED. INDICATION RETURNED & REMAINED UNTIL FLAPS 15 SELECTED. INDICATION RETURNED TWICE DUSDR AALA20160501004Proximity Sensor · faultyAIRCRAFT WAS GNDED. AIR INTERRUPT, EMER WAS DECLARED, LANDING UNEVENTFUL & ACFT WAS OVERWEIGHT. DURING CLIMB, NR 3 LE FLAP LIGHT CAME ILLUMINATED, THEN EXTINGUISHED, THEN ILLUMINATE & REMAINED ON. R & R F3 PROXIMITY EXTEND SENSOR IAW AMM 27-88-11. ACCOMPLISDR AALA20150908021Bulkhead · crackedWHEEL WELL BULKHEAD WEB AT FS 663.75 HAS MULTIPLE CRACKS, BETWEEN LBL 43.80 & RBL 43.80. REPAIRED WEB IAW EA 254352 & EA 253962. R & R PREVIOUSLY ACCOMPLISHED TIME LIMITED REPAIRS WITH PERMANENT REPAIRS IAW SRM 51-10-10-2R. ALTERNATIVE REPAIR 2 & EA 260729.SDR AALA20150527010Fseu · inoperativeAFTER TAKEOFF, SELECTED FLAPS UP. FLAPS INDICATOR SHOWED A SPLIT & REMAINED AT FLAPS 1 DEGREE. LANDED WITH FLAPS AT 1B DEGREE. REPLACED THE FSEU.SDR AALA20150330006Sensor · faultyAIR INTERRUPT, DIVERTED & EMER DECLARED. LANDING UNEVENTFUL & ACFT NOT OVERWEIGHT. DURING CLIMB FLAPS WOULD NOT RETRACT PAST FLAPS 1 WITH LT FLAP INDICATING SLIGHTLY HIGHER. REPLACED NR 1 TE FLAP SKEW SENSOR IAW MM REF 27-59-01. ACCOMPLISHED FLAP SKEW DETESDR AALA20150321007Connector · contaminatedAIR INTERRUPT, EMER DECLARED, LANDING UNEVENTFUL & ACFT WAS NOT OVERWEIGHT. RETURNED DUE TO FLAP ASYMMETRY INDICATION, FAULT FLAP 1 SKEW MSG 27-53250. FOUND ELEC CONNECTOR ON NR 1 SKEW SENSOR WET & DIRTY. CLEANED SENSOR & VERIFIED NO DAMAGE. ACCOMPLISHED SSDR AALA20141105003Smoke Detector · false activationLAVATORY SMOKE WARNING CAME ON AT 18000 FEET IN DESCENT. WARNING WENT OFF AT 3000 FEET. VISUALLY INSPECTED & FOUND NO SMOKE IN ANY LAVATORY. R & R SMOKE DETECTORS IN ALL 3 LAVATORIES IAW AMM 26-14-01-00-801, 26-14-01-400-801 & 26-14-00-730-801. SYSTEMS CHESDR AALA20140703004Skate Angle · corrodedCORROSION FOUND AT STATION 540 BETWEEN STRINGERS 21 & 22 RT. REMOVED 540 SKATE ANGLE. BLENDED OUT CORROSION IAW EA B737-57-035569 & REINSTALLED SKATE ANGLE.SDR AALA20140523004Skin · damagedAFT FWD CARGO CUT OUT SURROUND SKIN BENEATH SCUFF PLATE DAMAGED. ACCOMPLISHED REPAIR IAW EA B737-53-035009.SDR AALA20140516016Seat Track · crackedCRACKS IN OTBD SEAT TRACK & SPLICE STRAPS AT STATION 727B & LBL 24.75. ACCOMPLISHED REPAIR IAW ECO J1698 ECO 1707.
Back to N938AN