N907AN
Service difficulty reports · 258
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 = 'N907AN' 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 = 'N907AN' 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 AALA20130412015Engine · failedDFW - CREW REPORTED NUMBER TWO ENGINE FAILED DURING CLIMBOUT. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED RIGHT ENGINE AT DFW ON 04/14/2013. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20130212016Spar · corrodedRIGHT WING FRONT SPAR CORRODED AT BOOST PUMP LOWER BONDING STRAP. REMOVED CORROSION AND REPAIRED AREA PER EA B737-57-028293.SDR AALA20130211004Intercostal · crackedCRACKED INTERCOSTAL DISCOVERED ON AC LC VISUAL INSPECTION. REMOVED AND REPLACED INTERCOSTAL PER SRM 51-10-2.SDR AALA20121221006Floorbeam · corrodedCORROSION ON FLOORBEAM AT STATION 986 RIGHT BUTTLINE 44. INSTALLED REPAIR ANGLE AND SHIM PER EA B737-53-027480.SDR AALA20121221005Floorbeam · corrodedCORROSION ON FLOORBEAM AT STATION 986 FROM LEFT BUTTLINES 30 TO 45. INSTALLED REPAIR ANGLE AND SHIM PER EA B737-53-027480.SDR AALA20121218005Intercostal · corrodedCORROSION FOUND ON INTERCOSTAL AT APPROXIMATELY STATION 930.5, LEFT BUTTLINE 25. INSTALLED NEW INTERCOSTAL PER AARD 51-00-05-1.SDR AALA20121218004Intercostal · corrodedCORROSION FOUND ON INTERCOSTAL AT STATION 945 BETWEEN LEFT BUTTLINES 50 AND 51.5. REPLACED INTERCOSTAL PER AARD 51-00-05-1 REPAIR 1.SDR AALA20121217008Tee Fitting · damagedTOOLING MARKS ON T CLIP BACKSIDE STATION 927 LEFT BUTTLINE 25 THAT CONNECTS TO INTERCOSTAL BETWEEN STATIONS 927 AND 947. INSTALLED NEW T ANGLE PER EA B737-53-027575.SDR AALA20121218002Intercostal · corrodedLAVATORY SUPPORT (INTERCOSTAL) HAS CORROSION. REMOVED AND REPLACED INTERCOSTAL PER AARD 51-00-05.SDR AALA20121213001Support · corrodedCORROSION ON GALLEY WALL SUPPORT AT STATION 992, RIGHT BUTTLINES 32 TO 44. REPLACED SUPPORT PER AARD 51-00-05-1 REPAIR 1.SDR AALA20120911003Battery Pack · dischargedEMERGENCY LIGHTS FROM ROWS 12 TO 14 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS FROM ROWS 12 TO 14. OPS CHECK NORMAL.SDR AALA20120827005Battery Pack · dischargedEMERGENCY LIGHTS AT ROWS 3 TO 6 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT ROWS 3 TO 6. OPS CHECK NORMAL.SDR AALA20120603005Actuator · failedORD - CREW REPORTED AFTER TAKEOFF UNABLE TO TRANSFER FUEL FROM CENTER TANK. EMERGENCY DECLARED FLIGHT RETURNED ORD LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED ACTUATOR FOR ENGINE FUEL CROSSFEED VALVE. SYSTEM GROUND CHECK NORMAL OPERATISDR AALA20120515001Light · inoperativeOVERWING EXIT LIGHT INOPERATIVE. REPLACED LAMP FOR OVERWING EXIT LIGHT, OPS CHECK NORMAL.SDR AALA20120424003Light · inoperativeCEILING EMERGENCY LIGHT IN AFT CABIN BETWEEN LAVATORIES INOPERATIVE. REPLACED LAMP FOR CEILING EMERGENCY LIGHT IN AFT CABIN BETWEEN LAVATORIES.SDR AALA20120304010Shutoff Valve · inoperativeDFW - INFLIGHT ORD-MEX. CREW REPORTED NUMBER 1 ENGINE BLEED TRIP OFF LIGHT ILLUMINATED. FLIGHT DIVERTED DFW LANDED WITHOUT INCIDENT. REPLACED LEFT ENGINE PRESSURE REGULATING SHUT OFF VALVE. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20120117BOS01Pressure Switch · defectiveBOS - CREW REPORTED WARNING ON CENTER FUEL PUMPS. LEFT FAULTED IN FLIGHT AND RIGHT PUMP ALREADY ON MEL. FLIGHT RETURNED BOS LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LEFT AFT FUEL PRESSURE SWITCH. SYSTEM GROUND CHECK NORMAL OPERATIOSDR AALA20110906ORD01Battery Pack · dischargedSEVERAL LIGHTS FAILED TO ILLUMINATE. REMOVED AND REPLACED BATTERY PACK ON RIGHT SIDE FOR ROW 22 AND AFT.SDR AALA20100610ATL01Module · faultyATL - INFLIGHT MSP-MIA. CREW REPORTED NUMBER ONE ENGINE B-LOOP FAULT OVERHEAT LIGHT ILLUMINATED INTERMITTENTLY. FLIGHT RETURNED ATL LANDED WITHOUT INCIDENT. REPLACED FIRE WARNING MODULE THAT HAD FAULTED. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA2009020900031Bulkhead · damagedFASTENER MISDRILLED AT AFT PRESSURE BULKHEAD THIRD FASTENER INBOARD AT THREE O’CLOCK POSITION. REPAIRED DAMAGED AREA OF BULKHEAD IN ACCORDANCE WITH ESO 61000 DATED 29 JAN 2009.SDR AALA2009020900022Bulkhead · canningAFT PRESSURE BULKHEAD OIL CANNING JUST AFT OF STA 1016 APPROX 3 O`CLOCK, 6 INCH BY 6 INCH AREA. REPAIRED DAMAGED AREA OF BULKHEAD PER ESO 61000 DATED 29 JAN 09.SDR AALA2009020900024Seat Track · wornCAPTAINS INBOARD AFT SEAT TRACK HAS EXCESSIVE WEAR. REPLACED CAPTAINS INBOARD AFT SEAT TRACK.SDR AALA2009020900023Seat Track · wornFIRST OFFICER AFT SEAT TRACK HAS EXCESSIVE WEAR. REPLACED FIRST OFFICER AFT INBOARD SEAT TRACK.SDR AALA2009020900034Floorbeam · corrodedCORROSION ON TOP OF FLOORBEAM 23 TO 29 INCHES AT STATION 294.5. REPAIRED IN ACCORDANCE WITH ESO 61000 DATED 26 JAN 2009.SDR AALA2009020900033Skin · dentedFUSELAGE SKIN DENTED 24 INCHES ABOVE FORWARD ENTRY DOOR AT STATION 320 TO 328. AREA OF DISCREPANCY IS 4 INCHES BY 8 INCHES. STRINGER 3 LEFT DAMAGED. INSTALLED STRINGER REPAIR CHANNEL AND EXTERNAL DOUBLER ON FUSELAGE SKIN IN ACCORDANCE WITH ESO 61000 DATED 2SDR AALA2009020900032Floorbeam · corrodedCORROSION IN NINE PLACES ON TOP OF FLOORBEAM AT STATION 328 FROM RIGHT BUTTLINE 1 TO RIGHT BUTTLINE 51.5. REPLACED UPPER FLOORBEAM CHORD FROM RIGHT BUTTLINE 1.6 TO RIGHT OUTBOARD END IN ACCORDANCE WITH ESO 61000 DATED 29 JAN 2009.SDR AALA2009020900027Web · crackedDOOR SEAL WEB 328 AT R2 DOOR HAS VISIBLE CRACK LOCATED BELOW DOOR THRESHOLD. REPAIRED IN ACCORDANCE WITH SRM 51 70 13 2R.SDR AALA2009020900030Intercostal · crackedFLOORBEAM INTERCOSTAL CRACKED AT STATION 353.5 BUTTLINE 0. REPLACED INTERCOSTAL IN ACCORDANCE WITH SRM 51 10 02.SDR AALA2009020900029Intercostal · crackedFLOOR INTERCOSTAL CRACKED AT STATION 335 AT LEFT BUTT LINE 45.5. INSTALLED NEW INTERCOSTAL IN ACCORDANCE WITH SRM 51 10 02.SDR AALA2009020900028Intercostal · crackedINTERCOSTAL CRACKED STATION 284.5. INSTALLED NEW INTERCOSTAL IN ACCORDANCE WITH SRM 51-10-02-0G.SDR AALA2009020900038Floor Support · corrodedFLOORBOARD SUPPORT CHORD CORRODED AT STATION 310 RIGHT BUTTLINE 55. REPAIRED CHORD IN ACCORDANCE WITH SRM 51-70-11-2R.SDR AALA2009020900037Floorboard · corrodedCORROSION ON FLOORBOARD AND DOOR SILL SUPPORT CREASE ANGLE AT STATION 980 TO 993 AND RIGHT BUTTLINE 48. REPAIRED ANGLE IN ACCORDANCE WITH SRM 51 70 11 2R.SDR AALA2009020900026Floorbeam · corrodedCORROSION ON FLOORBOARD SUPPORT ZEE ANGLE AT STATION 994 BETWEEN RIGHT BUTTLINE 33 AND 45. INSTALLED NEW ZEE ANGLE IN ACCORDANCE WITH SRM 51 10 02 08.SDR AALA2009020900025Floorbeam · corrodedCORROSION ON UPPER FLANGE OF FLOORBEAM AT STATION 986.5 30-34 INCHES ON RIGHT BODY LINE. INSTALLED ANGLE REPAIR ON FLOORBEAM PER AARD 53 00 00 7.SDR AALA2009020900036Floorbeam · corrodedCORROSION ON UPPER FLANGE OF CABIN FLOORBEAM AT STATION 986.5 LEFT BUTTLINE 4 TO 10.SDR AALA2009020900035Floorbeam · corrodedCORROSION FOUND ON FLOORBEAM UPPER FLANGE AT STATION 967 RIGHT BUTTLINE 18 AROUND FASTENER HOLE. REMOVED CORROSION BY CUTTING DAMAGED AREA OUT AND INSTALLING REPAIR ANGLE AND STRAP IN ACCORDANCE WITH SRM 53 00 51.SDR AALA200803060Pump · faultedDFW INFLIGHT - CREW REPORTED NUMBER TWO HYDRAULIC LOW PRESSURE INDICATION INTERMITTENTLY FOLLOWED BY NUMBER ONE HYDRAULIC LOW PRESSURE INDICATION. LANDED DFW WITHOUT INCIDENT. REPLACED NUMBER ONE AND TWO ENGINE DRIVEN PUMP AND CASE DRAIN FILTERS. SYSTEM GROSDR AALA200802019Shroud · damagedDFW EMERGENCY LIGHT SHROUD AT SEAT 16D DAMAGED. REPLACED SHROUD FOR EMERGENCY LIGHT AT SEAT 16D. SYSTEM GROUND CHECKED NORMAL OPS. (CLOSED)SDR AALA200800337Battery Pack · inoperativeTUL - EMERGENCY LIGHT BATTERY PACK FOR AFT CABIN INOPERATIVE. REPLACED BATTERY PACK AT STATION 952 FOR EMERGENCY LIGHTS IN AFT CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800338Battery Pack · inoperativeTUL - EMERGENCY LIGHT BATTERY PACK FOR FORWARD CABIN INOPERATIVE. REPLACED BATTERY PACK AT STATION 500 FOR EMERGENCY LIGHTS IN FORWARD CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070978Lens · missingDFW - AFT SEAT MOUNTED EMERGENCY LIGHT AT SEAT 14D MISSING LENS. REPLACED CLEAR LENS FOR AFT SEAT MOUNTED EMERGENCY LIGHT AT SEAT 14D.SDR AALA20070977Light · inoperativeDFW - SEAT MOUNTED EMERGENCY LIGHT AT FORWARD SEAT 14D INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR SEAT MOUNTED EMERGENCY LIGHT AT FORWARD SEAT 14D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070976Lens · missingDFW - EMERGENCY LIGHT AT LEFT AISLE BULL NOSE AT ROW 10 MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT LEFT AISLE BULL NOSE AT ROW 10. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070975Connector · inoperativeDFW - SEAT MOUNTED EMERGENCY LIGHTS AT SEAT 5E INOPERATIVE. REPAIRED CONNECTOR UNDER SEAT 5E FOR SEAT MOUNTED EMERGENCY LIGHTS AT SEAT 5E. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070974Lens · wrong partDFW - EMERGENCY LIGHT AT RIGHT AFT DOOR OVERHEAD EXIT SIGN HAS WRONG LENS. REPLACED LENS FOR EMRGENCY LIGHT AT RIGHT AFT DOOR OVERHEAD EXIT SIGN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070973Lens · wrong partDFW - EMERGENCY LIGHT AT LEFT AFT DOOR OVERHEAD EXIT SIGN HAS WRONG LENS. REPLACED LENS FOR EMERGENCY LIGHT AT LEFT AFT DOOR OVERHEAD EXIT SIGN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070972Lens · wrong partDFW - EMERGENCY LIGHT AT RIGHT NUMBER ONE DOOR OVERHEAD EXIT SIGN HAS WRONG LENS. REPLACED LENS FOR EMERGENCY LIGHT AT RIGHT NUMBER ONE DOOR OVERHEAD EXIT SIGN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070971Lens · wrong partDFW - EMERGENCY LIGHT AT LEFT NUMBER ONE DOOR OVERHEAD EXIT SIGN HAS WRONG LENS. REPLACED LENS FOR EMERGENCY LIGHT AT LEFT NUMBER ONE DOOR OVERHEAD EXIT SIGN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070970Light · brokenDFW - EMERGENCY LIGHT AT FORWARD GALLEY WALL HAS BROKEN BASE. REPLACED LIGHT BASE FOR EMERGENCY LIGHT AT FORWARD GALLEY WALL. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070416Battery Pack · inoperativeMIA - EMERGENCY LIGHT AT LEFT NUMBER FOUR DOOR INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT LEFT NUMBER FOUR DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to N907AN