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 AALA20130819004Tire · blownMIA CREW REPORTED ON TAKE OFF ROLL AIRCRAFT BLEW THE NR 2 TIRE DAMAGING THE LT INBD FLAP. EMERGENCY DECLARED FLIGHT RETURNED MIA LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED NR 1 & NR 2 MAIN TIRE ASSEMBLIES & REPLACED AFT FLAP & PANEL SDR AALA20120627004Skin · scratchedFUSELAGE HAS SCRATCH APPROXIMATELY 8 INCHES BY .004 INCHES DEEP BELOW AFT CARGO SILL PLATE. INSTALLED DOUBLER PER EA B737-53-02630.SDR AALA20120619011Intercostal · crackedCABIN FLOOR INTERCOSTAL FROM STATIONS 277 TO 294 CRACKED AT FASTENER HOLE. REMOVED AND REPLACED CABIN FLOOR INTERCOSTAL PER BOEING DRAWING 141A5400 AND AARD 51-00-05-1.SDR AALA20120618011Floorbeam · corrodedCORROSION ON THE STATION 986 FLOORBEAM RIGHT BUTTLINES 3 TO 43. REMOVED THE CORRODED SECTION OF FLOORBEAM AND INSTALLED FLOORBEAM PER SRM 53-70-51-2R4.SDR AALA20120617006Strap · wornWEAR SPOT ON STRAP JUST AFT OF STATION 291.5 FRAME, 12 INCHES ABOVE FORWARD SERVICE DOOR CUTOUT. REPLACED STRAP PER AARD 51-00-05-1 AND EA B737-53-024421.SDR AALA20120617003Angle · corrodedCREASE ANGLE CORRODED AT RIGHT NUMBER 1 DOOR. REMOVED AND REPLACED CREASE ANGLE PER AARD 51-00-05-1.SDR AALA20120616008Intercostal · crackedINTERCOSTAL CRACKED FROM STATIONS 312 TO 328, RIGHT BUTTLINE 31. REPLACED INTERCOSTAL FROM STATIONS 312 TO 328, RIGHT BUTTLINE 31 PER AARD 51-00-05-1.SDR AALA20120616007Floorbeam · corrodedCORROSION ON FLOORBEAM STATION 328, SPOTS BETWEEN LEFT BUTTLINE 18 TO RIGHT TERMINATION END. INSTALLED UPPER CHORD REPLACEMENT REPAIR ON FLOORBEAM STATION 328 PER SRM 53-10-51-2R 8 AND EA B737-53-024430.SDR AALA20120618002Web · corrodedCORROSION ON AFT SIDE OF WEB STATION 1125 AFTER VERTICAL STIFFENER REMOVAL. CUT OUT CORRODED SECTION OF WEB AND INSTALLED DOUBLER AT STATION 1125 PER SRM 51-70-13 REPAIR 3 AND EA B737-53-024414.SDR AALA20120615007Floor Support · corrodedCORROSION ON FLOORBOARD SUPPORT LOCATED BETWEEN STATIONS 328 AND 344, LEFT BUTTLINE 11. INSTALLED NEW FLOORBOARD SUPPORT BETWEEN STATIONS 328 AND 344 PER AARD 51-00-05-1.SDR AALA20120615006Intercostal · crackedINTERCOSTAL BETWEEN STATIONS 312 TO 328, RIGHT BUTTLINE 43 CRACKED AT FASTENER HOLE. INSTALLED NEW INTERCOSTAL BETWEEN STATIONS 312 TO 328 PER AARD 51-00-05-1.SDR AALA20120615005Intercostal · crackedINTERCOSTAL CRACKED BETWEEN STATIONS 328 TO 344, LEFT BUTTLINE 43. INSTALLED NEW INTERCOSTAL PER AARD 51-00-05-1.SDR AALA20120615004Floor Support · corrodedFLOOR STRUCTURE CORRODED, RIGHT BUTTLINE 10, STATIONS 294 TO 312. INSTALLED NEW FLOORBOARD SUPPORT PER AARD 51-00-05-1.SDR AALA20120613003Seat Track · crackedCABIN LEFT SIDE NUMBER 1 SEAT TRACK INBOARD FLANGE CRACKED AT STATION 727A+ 18. INSTALLED REPAIR STRAP PER EA B737-53-024345.SDR AALA20120613001Stiffener · corrodedVERTICAL STIFFENER IS CORRODED AT STATION 1125 AFT END OF INLET CUTOUT. REPLACED 1125 VERTICAL STIFFENER PER AARD 51-10-5 R1 AND BOEING DRAWING 148A8650.SDR AALA20120612017Skin · dentedAFT CARGO DOOR HAS SMALL 4 INCH DENTS, 6 INCHES ABOVE DOOR HANDLE. INSTALLED OUTER DOOR SKIN WITH NEW HANDLE BOX PER ESO 60651.SDR AALA20120611007Bracket · crackedAIR CONDITIONING BRACKET CRACKED AT STATION 500A LEFT. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AD CARD 006.SDR AALA20120609017Frame · crackedFRAME CRACKED AT AIR CONDITIONING RAIL ATTACH BRACKET AT STATION 727B RIGHT. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AD.SDR AALA20120609016Frame · crackedFRAME CRACKED AT AIR CONDITIONING RAIL ATTACH BRACKET AT STATION 440R. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AD.SDR AALA20120609014Frame · crackedFRAME CRACKED AT AIR CONDITIONING RAIL ATTACH BRACKET AT STATION 400R. INSTALLED FRAME REPAIR PER ECO J1159AD.SDR AALA20120609008Door Frame · damagedE AND E DOOR CUTOUT LEFT FRAME AND WEB WORN AT LATCH FITTING. INSTALLED NEW WEB PER SRM 53-10-15-01 3.SDR AALA20120615003Floor Support · corrodedFLOOR STRUCTURE CORRODED AT RIGHT BUTTLINE 10, STATIONS 312 TO 328. INSTALLED FLOORBOARD SUPPORT PER AARD 51-00-05-1.SDR AALA20120608004Vapor Barrier · crackedLEFT VAPOR BARRIER IS CRACKED BETWEEN BAYS 2 AND 4. INSTALLED CROSSBRACE REPAIRS TO BAYS 2L AND 4L PER SRM - WINGLET APB SUPPLEMENT 57-10-10-2R 2.SDR AALA20120606012Frame · crackedFRAME CRACKED AT STATION 400 LEFT SIDE BETWEEN STRINGERS 8 AND 9. INSTALLED REPAIR ANGLES PER ECO J1159AD CARD 0006.SDR AALA20120606001Stiffener · corrodedOUTBOARD VERTICLE STIFFENER CORRODED ON 1088 BULKHEAD AT AUXILIARY POWER UNIT INLET CUTOUT. REMOVED CORRODED STIFFENER AND INSTALLED NEW STIFFENER PER SRM 51-10-02, BOEING DRAWING 148A0924 AND EA B737-53-008825.SDR AALA20120607003Stiffener · crackedLEFT VERTICAL STIFFENER OUTBOARD OF PACK EXHAUST DUCT CUTOUT IS CRACKED AT LOWER END. REMOVED CRACKED STIFFENER AND INSTALLED NEW VERTICAL STIFFENER PER AARD 51-10-05-R1 AND BOEING DRAWING NUMBERS 111A1000 AND 111A-1308.SDR AALA20120606019Vapor Barrier · crackedRIGHT VAPOR BARRIER IS CRACKED BETWEEN BAYS 2 AND 4. INSTALLED REPAIR STRAPS AND ANGLES ON RIGHT VAPOR BARRIER AT BAYS 1, 2 AND 4 PER SRM SUP 57-10-10-2R, REPAIR 2.SDR AALA20120620001Bracket · crackedAIR CONDITIONING BRACKET CRACKED AT STATION 500C LEFT. INSTALLED DOUBLER PER ECO J1159AD CARD 006 AND EA B737-53-024495.SDR AALA20120619019Transition Panel · corrodedAFT CARGO FLOOR TRANSITION PANEL CORRODED. REMOVED AND REPLACED TRANSITION PANEL PER AARD 51-10-05 AND BOEING DRAWING 146A8127.SDR AALA20120619013Floor Support · corrodedCABIN FLOOR SUPPORT FROM STATIONS 312 TO 326 CORRODED. REMOVED AND REPLACED CABIN FLOOR SUPPORT PER BOEING DRAWING 141A5400 AND AARD 51-00-05-1.SDR AALA20120608005Web · corrodedCORROSION ON WEB ABOVE FORWARD DOOR STOP LEFT SIDE OF AUXILIARY POWER UNIT COMPARTMENT. CUT OUT DAMAGED AREA AND INSTALLED DOUBLER PER SRM 51-70-13-2R 1.SDR AALA20120606011Frame · crackedFRAME 480, RIGHT SIDE OF CABIN, CRACKED AT AIR CONDITIONING RAIL BETWEEN STRINGERS 8 AND 9. INSTALLED REPAIR ANGLES PER ECO J1159AD CARD 0007.SDR AALA20120606010Frame · crackedFRAME 500A, RIGHT SIDE OF CABIN, CRACKED AT AIR CONDITIONING RAIL BETWEEN STRINGERS 8 AND 9. INSTALLED REPAIR ANGLES PER ECO J1159AD CARD 0007.SDR AALA20120609003Vapor Barrier · crackedCRACK DAMAGE ON THE WING CENTER SECTION REAR SPAR VAPOR BARRIER. INSTALLED CROSSBRACE REPAIRS ON LEFT AND RIGHT VAPOR BARRIERS AT BAYS 2L, 4L AND 1R, 2R, 4R PER SRM SUP 57-10-10-2R, REPAIR 2.SDR AALA20120318002Module · inoperativeDFW - INFLIGHT PHX-ORD. CREW REPORTED AIRSPEED INDICATION SPLIT BETWEEN CAPTAIN AND FIRST OFFICERS AIRSPEED INDICATORS. EMERGENCY DECLARED FLIGHT DIVERTED DFW LANDED WITHOUT INCIDENT. REPLACED RIGHT PITOT AIR DATA MODULE. SYSTEM GROUND CHECK NORMAL OPERATSDR AALA20120211TUL06Web · corrodedCORROSION FOUND UNDER FORWARD CARGO SCUFF PLATE. INSTALLED NEW WEB PER AARD 51-00-05-1.SDR AALA20120117TUL09Windshield · crackedIAD - INFLIGHT JFK-SAN CREW REPORTED CAPTAINS WINDSHIELD CRACKED AFTER ARCING. EMERGENCY DECLARED FLIGHT DIVERTED IAD LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED CAPTAINS WINDSHIELD AND WINDOW HEAT CONTROLLER. SYSTEM GROUND CHECK NORMASDR AALA20110211MIA01Connector · disconnectedEMERGENCY LIGHT AT 15D INOPERATIVE. RECONNECTED CONNECTOR UNDER SEAT. OPS CHECK NORMAL.SDR AALA20101222ATL01Lens · crackedLENS FOR FORWARD ENTRY EMERGENCY EXIT LIGHT IN AISLE IS CRACKED. REPLACED FORWARD GALLEY EMERGENCY LIGHT ASSEMBLY. OPS CHECK NORMAL.SDR AALA20100519MCO01Sense Line · looseIN FLIGHT MIA TO DCA AIR INTERRUPT INTO MCO DUE TO LEFT ENGINE BLEED INOPERATIVE. PLACARD LEFT ENGINE BLEED INOPERATIVE PER MEL 36-05 AND ACCOMPLISHED MEL VALVE IN CLOSED LOCK POSITION. AT DCA FOUND LENSE LINE LOOSE. TIGHTENED SENSE LINE ON BLEED AIR REGULASDR AALA20100128TUL17Skin · dentedLEFT LEADING EDGE HORIZONTAL STAB DAMAGE FOUND TO BE AT APPROXIMATELY 15 INCHES FROM OUTBOARD END NOT 4 INCH FROM OUTBOARD END AS STATED IN ADL 0010 WIP. REMOVED DENT AND INSTALLED RIB PER EA B737-55-008879. DYE CHECKED AREA, NO CRACK FOUND.SDR AALA20091113TUL04Window · crackedINFLIGHT MIA TO YUL. CREW REPORTED NUMBER FIVE EYEBROW WINDOW INNER PANE CRACKED. FLIGHT DESCENDED TO LOWER ALTITUDE. LANDED BWI WITHOUT INCIDENT. REPLACED NUMBER FIVE WINDOW ASSEMBLY.SDR AALA20090806TUL03Skin · scratchedSCRATCHES ON FUSELAGE SKIN ABOVE LEFT NUMBER ONE DOOR. REPAIRED UNDER EA B737-53-007019.SDR AALA200803203Lens · brokenDFW - EMERGENCY LIGHT AT SEAT 7D HAS BROKEN LENS. REPLACED LENS AT SEAT 7D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200803202Lens · brokenDFW - EMERGENCY LIGHT AT SEAT 7D HAS BROKEN LENS. REPLACED LENS AT SEAT 7D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200803201Lamp · burned outDFW - EMERGENCY LIGHT AT SEAT 18D INOPERATIVE. REPLACED LAMP AT SEAT 18D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061006Battery Pack · dischargedLAX - EMERGENCY LIGHT AT RIGHT AFT OVERWING HATCH INOPERATIVE. REPLACED BATTERY PACK M1671 FOR EMERGENCY LIGHT AT RIGHT AFT OVERWING HATCH. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060782Battery Pack · inoperativeTUL - EMERGENCY LIGHTS IN CABIN FAILED TEST. REPLACED BATTERY PACK FOR INOPERATIVE EMERGENCY LIGHTS IN CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060052Connector · inoperativeMIA - EMERGENCY LIGHT AT SEAT 25D INOPERATIVE. RESECURED CONNECTOR UNDER SEAT 25D FOR EMERGENCY LIGHT AT SEAT 25D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050625Battery Pack · inoperativeTUL - EMERGENCY LIGHTS AT FIRST CLASS SEATS INOPERATIVE. REPLACED BATTERY PACKS FOR EMERGENCY LIGHTS AT FIRST CLASS SEATS. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to N947AN