N947AN
Service difficulty reports · 202
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 = 'N947AN' 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 = 'N947AN' 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 AALA201806051009Support Angle · corrodedCORROSION WAS FOUND ON THE ZEE ANGLE AT BS 1016, RBL 32. REPLACED ANGLE IAW 51-00-05-1.SDR AALA201806051006Web · corrodedTHE DOORWAY WEB WAS FOUND TO HAVE CORROSION IN SEVERAL SPOTS. REPLACED ENTIRE WEB ASSEMBLY AT THE AFT CARGO THRESHOLD IAW 51-00-05-R1.SDR AALA201806041016Floor Support · corrodedCORROSION FOUND ON THE ON FLOOR SUPPORT BS 951, LBL 22. REPAIRED THE FLOOR SUPPORT IAW 51-00-05-1 AND DRAWING 147A5650.SDR AALA201805310010Floorbeam · corrodedCORROSION ON THE TOP OF THE FLOORBEAM, BS 947.5, LBL 4. REPAIRED THE FLOORBEAM IAW SRM 53-00-51-2R-1, AND SRM 51-40-02.SDR AALA201805310008Floor Support · corrodedCORROSION ON THE FLOOR SUPPORT AROUND A FASTENER AT BS 951, LBL 17. REPLACED THE FLOOR SUPPORT IAW SRM 51-00-05-1R-1.SDR AALA201805310005Skin · crackedCRACK ON LOWER SKIN OF THE LEFT HORIZONTAL STABILIZER ALONG THE RIB LINE AT HSS 129.50. REPAIRED THE SKIN IAW 55-10-01-2R-11.SDR AALA2018053100009Floorbeam · corrodedCORROSION FOUND ON THE TOP OF THE FLOORBEAM BS 947.5, RBL 4. REPAIRED THE FLOORBEAM IAW SRM 53-00-51-2R, AND SRM 51-40-02.SDR AALA2018053100006Transition Panel · corrodedCORROSION FOUND ON THE RIGHT TRANSITION PANEL BETWEEN BS 747 - 787. REPLACED THE TRANSITION PANEL IAW SRM 53-00-53-1A-2.SDR AALA20180528004Floorbeam · corrodedTHE AIRCRAFT IS IN BASE MAINTENANCE. CORROSION FOUND ON TOP OF FLOORBEAM AT STATION 951 LBL 50.5. REPLACED FLOORBEAM PER 51-00-05.SDR AALA20180528002Floorbeam · corrodedTHE AIRCRAFT IS IN BASE MAINTENANCE. SEVERAL AREAS OF CORROSION FOUND OUT OF LIMITS ALONG UPPER T CHORD AT STATION 986.5 FROM LBL 53 TO RBL 53. REPAIRED UPPER T CHORD PER SRM 53-70-51-2R-4.SDR AALA201805295009Strap · corrodedAFT CARGO INTERCOSTAL STRAP HAS CORROSION AT BS 787 PLUS 5 INCHES, STRINGER 24L. REPLACED THE STRAP IAW 51-00-05-1.SDR AALA20180524005Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION ON RIGHT HAND TRANSITION PANEL BETWEEN STA 727I TO STA 747. REPLACED TRANSITION PANEL PER SRM 53-00-53-1A-2.SDR AALA20180523006Shield · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION FOUND IN SEVERAL AREAS OF THE RIGHT HAND SHIELD ASSEMBLY BETWEEN STA 767 TO STA 787. REPLACED SHIELD ASSEMBLY PER AARD 51-00-05 AND SRM 51-10-02.SDR AALA20180523001Angle · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION FOUND ON RIGHT CREASE ANGLE BETWEEN STA 325 TO STA 332 AT FORWARD SERVICE DOOR AREA. REPLACED CREASE ANGLE PER 51-00-05-1.SDR AALA20180522004Intercostal · crackedTHE AIRCRAFT IS IN BASE MAINTENANCE. INTERCOSTAL CRACKED AT AFT HOLE, STATIONS 277-294, BL0. REPLACED INTERCOSTAL PER 51-00-05-1.SDR AALA2018052118003Floor Support · crackedCRACKED FLOOR SUPPORT BETWEEN BS 312 TO 328, LBL 46. REPLACED THE FLOOR SUPPORT IAW DWG 141A5410, AND 51-00-05-1.SDR AALA2018052118005Channel · corrodedCORROSION FOUND ON THE RIGHT TRANSITION PANEL CHANNEL AT BS 947.5. REPLACED THE CHANNEL IAW 53-00-53.SDR AALA2018052118004Floor Support · crackedTWO CRACKS WERE FOUND ON THE FLOOR SUPPORT IN THE FORWARD CABIN BETWEEN BS 312-328, RBL 31. INSTALLED A NEW FLOOR SUPPORT IAW 51-00-05-1, AND DRAWING 141A5400.SDR AALA201806051012Floorbeam · corrodedFORWARD CARGO FLOORBEAM ATTACH ANGLE WAS CORRODED FROM THE LT TRANSITION PANEL TO THE RT TRANSITION PANEL, BS 500I. REPLACED FLOORBEAM ATTACH ANGLE IAW 51-00-05-1.SDR AALA2018053009002Rib · crackedCRACKED FOURTH RIB STIFFENER INSIDE THE RIGHT HORIZONTAL STABLIZER AT HSS 92.70 AT THE BOTTOM END, IN THE RADIUS WHERE STIFFENER STARTS TO WIDEN. REPAIRED THE RIB IAW SRM 55-10-09-2R-4.SDR AALA20180526003Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION ON RIGHT HAND TRANSITION PANEL BETWEEN STA 500A TO STA 500B. REPLACED TRANSITION PANEL PER 51-00-05-1 AND DRAWING 143A7501.SDR AALA20180527004Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION ON RIGHT HAND TRANSITIONAL PANEL BETWEEN STA 500 AND STA 500A. REPLACED RIGHT HAND TRANSITION PANEL PER SRM 51-10-2.SDR AALA2018042659038Sign · detachedEXIT SIGN OVER THE FORWARD GALLEY DOOR DETACHED. REMOVED AND REPLACED THE SIGN IAW MM 33-51-01. OPS CHECKED GOOD. OK FOR SERVICE.SDR AALA201804019007Fan · failedDURING CLIMB OUT, THROUGH 8000 FT, THE FLIGHT ATTENDANTS REPORTED A STONG ODOR OF BURNED RUBBER. SOME REPORTED A SLIGHT HAZE. RETURNED TO DEPARTURE, AN EMERGENCY WAS DECLARED. LANDED WITHOUT INCIDENT. THE AIRCRAFT WAS REMOVED FROM SERVICE. FOUND THE RIGHSDR AALA201803219019Lens · missingEMERGENCY EXIT LIGHT LENS MISSING AT SEAT ROW 15F. REPLACED THE LENS.SDR AALA201803209011Cover · missingEMERGENCY EXIT COVER MISSING AT SEAT ROW 15F. REPLACED EMERGENCY LIGHT COVER.SDR AALA201803209002Cover · detachedEMERGENCY EXIT SIGN COVER DETACHED FROM THE AFT GALLEY WALL. REPLACED THE AFT EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-01.SDR AALA201802019019Snubber · faultedENTRY DOOR HYDRAULIC ASSIST WAS NOT WORKING. DOOR WAS CLOSING TOO QUICKLY. AIRCRAFT WAS GROUNDED. MAINTENANCE REPLACED THE L1 DOOR SNUBBER ASSEMBLY IAW AMM 52-11-51, AND PERFORMED A SATISFACTORY OPS CHECK.SDR AALA201711089023Lens · brokenEMERGENCY EXIT LIGHT BY THE L1 DOOR HAS A BROKEN LENS. REMOVED AND REPLACED THE SIGN IAW AMM 33-51-01. OPS CHECKED GOOD.SDR AALA201709089024Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT THE R1 DOOR HAS A DETACHED LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201708239035Girt Bar · out of alignmentR1 DOOR SLIDE GIRT BAR SLEEVE IS IMPROPERLY ALIGNED MAKING IT DIFFICULT TO ARM & DISARM. ALIGNED THE GIRT BAR IAW AMM 25-66-01. OPERATIONAL CHECKED GOOD.SDR AALA201708089051Smoke Warning · faultyTHE AIRCRAFT WAS NOT GROUNDED. SMOKE DETECTOR AURAL AND VISUAL ALERT INTERMITTENT. DISAGREES WITH CONDITION. ACCOMPLISHED SMOKE DETECTOR TEST PER AMM 26-14-00 OPERATION CHECK NORMAL.SDR AALA201707249047Sign · looseTHE AIRCRAFT WAS NOT GROUNDED. F/C GALLEY EXIT LIGHT LOOSE AND WILL NOT STAY ON. REMOVED AND REPLACED EXIT SIGN ASSY IAW AMM 33-51-01 OPS CKS GOOD IAW AMM 33-51-01.SDR AALA201706289020Cover · missingTHE AIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT COVER MISSING AISLE SIDE OF F/C GALLEY WALL. REPLACED LIGHT ASSEMBLY IAW MM 33-51-02.SDR AALA201705059041Bustle · looseAIRCRAFT WAS NOT GROUNDED. FORWARD SERVICE DOOR SLIDE BUSTLE IS LOOSE AND PARTIALLY DETACHED. TIGHTENED FORWARD SERVICE DOOR SLIDE BUSTLE AS REQUIRED.SDR AALA201705039010Clamp · missingAIRCRAFT WAS GROUNDED. EMERGENCY DECLARED. DFW-SNA FLIGHT DIVERTED TO ELP ACCOUNT PASSENGERS IN ROWS 17 AND 18 REPORTED THUMPING NOISE COMING FROM FLOOR, LANDING UNEVENTFUL. INSPECTED AIRCRAFT AND FLIGHT CONTINUED TO SNA. FOUND A LOOSE B-NUT AND MISSING CLSDR AALA20170501004B-Nut · looseAIRCRAFT WAS GROUNDED. EMERGENCY DECLARED. DFW-SNA FLIGHT DIVERTED TO ELP ACCOUNT PASSENGERS IN ROWS 17 AND 18 REPORTED THUMPING NOISE COMING FROM FLOOR, LANDING UNEVENTFUL. INSPECTED AIRCRAFT AND FLIGHT CONTINUED TO SNA. FOUND A LOOSE B-NUT AND MISSING CLSDR AALA20161121010Lens · detachedAIRCRAFT NOT GROUNDED. AFT GALLEY EMERGENCY EXIT LIGHT LENS COVER DETACHED. REINSTALLED LENS COVER IAW AMM 25-63-00. OPERATIONAL CHECK GOOD.SDR AALA20160824002Bulkhead Web · crackedCRACK FOUND ON THE VERTICAL PRESSURE DECK WEB BS 663, LBL 40 TO 45.64, AT THE LOWER INBOARD CORNER OF THE INSPECTION AREA. REMOVED THE DAMAGE WEB AND INSTALLED NEW DOUBLERS REPAIRS IAW SRM 57-10-10-2R-3.SDR AALA20150617011Buss · defectiveAIR INTERRUPT, DIVERTED, NO EMER WAS DECLARED, LANDING WAS UNEVENTFUL & ACFT WAS NOT OVERWEIGHT. NR 2 SOURCE OFF LIGHT ILLUMINATED IN FLIGHT. PRIOR TO SOURCE OFF LIGHT THE NR 1 TR UNIT AMPS WERE FLUCTUATING BETWEEN 5 - 0. THE TR UNIT LIGHT ILLUMINATED INTERSDR AALA20150617010Gcu · defectiveAIR INTERRUPT, DIVERTED, NO EMER WAS DECLARED, LANDING WAS UNEVENTFUL & ACFT WAS NOT OVERWEIGHT. NR 2 SOURCE OFF LIGHT ILLUMINATED IN FLIGHT. PRIOR TO SOURCE OFF LIGHT THE NR 1 TR UNIT AMPS WERE FLUCTUATING BETWEEN 5 - 0. THE TR UNIT LIGHT ILLUMINATED INTERSDR AALA20150614002Idg · malfunctionedAIR INTERRUPT, DIVERTED, NO EMER WAS DECLARED, LANDING WAS UNEVENTFUL & ACFT WAS NOT OVERWEIGHT. NR 2 SOURCE OFF LIGHT ILLUMINATED IN FLIGHT. PRIOR TO SOURCE OFF LIGHT THE NR 1 TR UNIT AMPS WERE FLUCTUATING BETWEEN 5 - 0. THE TR UNIT LIGHT ILLUMINATED INTERSDR AALA20150608006Limit Switch · faultyAIR INTERRUPT, EMER DECLARED, LANDING UNEVENTFUL & ACFT NOT OVERWEIGHT. DURING CLIMB LG WOULD NOT RETRACT. R & R THE LG HANDLE MODULE IAW AMM 32-31-11 & LG MANUAL EXTENSION LIMIT SWITCH IAW WDM 32-35-11. PERFORMED GEAR SWING IAW AMM 32-09-00 & 07-11-01. SYSDR AALA20150604002Module · faultyAIR INTERRUPT, EMER DECLARED, LANDING UNEVENTFUL & ACFT NOT OVERWEIGHT. DURING CLIMB LG WOULD NOT RETRACT. R & R THE LG HANDLE MODULE IAW AMM 32-31-11 & LG MANUAL EXTENSION LIMIT SWITCH IAW WDM 32-35-11. PERFORMED GEAR SWING IAW AMM 32-09-00 & 07-11-01. SYSSDR AALA20140927005Bulkhead · canningAFT PRESS BULKHEAD LT OF CTR HAS OIL CANNING. ACCOMPLISHED REPAIR IAW EA 737-53-036750.SDR AALA20140902019Skin · corrodedCORROSION ON LOWER SURFACE OF CTR WING SKIN AT STATION 540, LT SIDE UNDER WING TO FUSELAGE ATTACH ANGLE. REMOVED CORROSION & REPAIRED IAW EA B737-57-036374.SDR AALA20140902018Skin · corrodedCORROSION ON FUSELAGE SKIN AT STATION 888 BETWEEN STRINGERS 28 LT & 28 RT. INSTALLED DOUBLER REPAIR IAW EA B737-53-036293.SDR AALA20140824009Skin · crackedLEFT LOWER HORIZONTAL STABILIZER SKIN CRACKED. REMOVED DAMAGE & INSTALLED REPAIR FILLER & DOUBLER IAW SRM 55-10-01-2R-11.SDR AALA20140619003Seat Track · crackedCRACK EMANATING FROM FASTENER HOLE OF INBD & OTBD FLANGE OF THE SEAT TRACK SUPPORT TOP CHORD JUST FWD OF STATION 727B. ACCOMPLISHED REPAIR IAW EA B737-53-035392.SDR AALA20131019006Sealant · inadequateORD LOUD AIR LEAK AT LT NR 1 DOOR ON CLIMB OUT. EMERGENCY DECLARED FLIGHT RETURNED ORD LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. APPLIED NEW SEALANT ON LOWER SCUFF PLATE AREA. SYSTEM GROUND CHECKED NORMAL OPERATION CLOSED.
Back to N947AN