N904AN
Service difficulty reports · 263
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 = 'N904AN' 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 = 'N904AN' 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 AALA20141109004Angle · corrodedAFT CARGO COMPARTMENT RT Z TRANSITION ANGLE CORRODED BETWEEN FUSELAGE STATIONS 727 & 767 AT RBL 27. R & R ENTIRE LENGTH OF TRANSITION ANGLE IAW SRM 53-00-53.SDR AALA20141107012Door Sill · corrodedCORROSION ON THE AFT CARGO DOOR OPENING LOWER SILL WEB BETWEEN FUSELAGE STATIONS 800 & 847. R & R WITH NEW PART IAW SRM 53-60-15.SDR AALA20141107011Plate · corrodedCORROSION WAS FOUND ON THE FWD CARGO LT SIDE PLATE FROM FUSELAGE STATION 400 TO 420 AT STRINGER 25 LT. R & R LT SIDE PLATE FROM FUSELAGE STATIONS 400 TO 500 IAW SRM 53-00-53.SDR AALA20141106011Angle · corrodedCORROSION WAS FOUND ON THE RT TRANSITION ANGLE BETWEEN FUSELAGE STATION 767 & 787 AT RBL 21. R & R TRANSITION ANGLE IAW AARD 51-10-05.SDR AALA20141031003Door Sill · corrodedFORWARD CARGO DOOR CUT OUT, LOWER SILL WEB HAS CORROSION IN SEVERAL AREAS. R & R WEB IAW AARD 51-10-05.SDR AALA20131114006Lens · missingSEAT MOUNTED LIGHT AT ROW 13 MISSING LENS. REPLACED LENS FOR SEAT MOUNTED LIGHT AT ROW 13. OPERATIONS CHECKED NORMAL.SDR AALA20131112001Light · missingSEAT MOUNTED LIGHT AT ROW 13 MISSING LAMP. REPLACED LAMP FOR SEAT MOUNTED LIGHT AT ROW 13. OPERATIONS CHECKED NORMAL.SDR AALA20131017035Seat Track · crackedSEAT TRACK AT STATION 727 & LBL 45.50 CRACKED. INSTALLED DOUBLER.SDR AALA20131017033Seat Track · crackedSEAT TRACK AT STATION 727 & LBL 24.75 CRACKED. INSTALLED DOUBLER.SDR AALA20131017032Seat Track · crackedSEAT TRACK AT STATION 727 & RBL 24.75 CRACKED. INSTALLED DOUBLER.SDR AALA20131017031Seat Track · crackedSEAT TRACK AT STATION 727 & RBL45.50 CRACKED. INSTALLED DOUBLER.SDR AALA20130109017Fseu · faultySEA - CREW REPORTED DURING APPROACH FLAPS STUCK AT APPROXIMATELY 2 DEGREES. EXTENDED FLAPS TO 15 USING ALTERNATE FLAP SYSTEM PER QRH. EMERGENCY DECLARED FLIGHT LANDED WITHOUT INCIDENT. REPLACED FLAP SLAT ELECTRONICS UNIT. SYSTEM GROUND CHECK NORMAL OPERATISDR AALA20121217028Skin · corrodedFUSELAGE SKIN FROM STATIONS 1064 TO 1088 BETWEEN STRINGERS 26 AND 27 RIGHT CORRODED. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-027457.SDR AALA20121217027Skin · corrodedFUSELAGE SKIN FROM STATIONS 1040 TO 1064 BETWEEN STRINGERS 26 AND 27 RIGHT CORRODED. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-027457.SDR AALA20121217026Skin · corrodedFUSELAGE SKIN FROM STATIONS 1016 TO 1040 BETWEEN STRINGERS 26 AND 27 RIGHT CORRODED. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-027457.SDR AALA20121217025Skin · corrodedFUSELAGE SKIN FROM STATIONS 1016 TO 1040 BETWEEN STRINGERS 25 AND 24 RIGHT CORRODED. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-027457.SDR AALA20121217023Skin · corrodedFUSELAGE SKIN FROM STATIONS 1040 TO 1064 BETWEEN STRINGERS 25 AND 24 RIGHT CORRODED. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-027457.SDR AALA20121217022Skin · corrodedFUSELAGE SKIN FROM STATIONS 1064 TO 1088 BETWEEN STRINGERS 25 AND 24 RIGHT CORRODED. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-027457.SDR AALA20121217021Skin · corrodedFUSELAGE SKIN FROM STATIONS 1064 TO 1088 BETWEEN STRINGERS 26 AND 25 RIGHT CORRODED. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-027457.SDR AALA20121217020Skin · corrodedFUSELAGE SKIN FROM STATIONS 1040 TO 1064 BETWEEN STRINGERS 26 AND 25 RIGHT CORRODED. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-027457.SDR AALA20121217019Skin · corrodedFUSELAGE SKIN FROM STATIONS 1016 TO 1040 BETWEEN STRINGERS 26 AND 25 RIGHT CORRODED. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-027457.SDR AALA20121217018Skin · corrodedFUSELAGE SKIN FROM STATIONS 987 TO 1016 BETWEEN STRINGERS 23 AND 25 RIGHT CORRODED. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-027457.SDR AALA20121217017Skin · corrodedFUSELAGE SKIN FROM STATIONS 927 TO 1016 BETWEEN STRINGERS 25 AND 26 RIGHT CORRODED. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-027457.SDR AALA20121217016Skin · corrodedFUSELAGE SKIN FROM STATIONS 1016 TO 1040 BETWEEN STRINGERS 23 AND 25 LEFT CORRODED. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-027457.SDR AALA20121217015Skin · corrodedFUSELAGE SKIN FROM STATIONS 1006 TO 1016 BETWEEN STRINGERS 23 AND 25 LEFT CORRODED. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-027457.SDR AALA20121217014Skin · corrodedFUSELAGE SKIN FROM STATIONS 967 TO 987 BETWEEN STRINGERS 21 AND 23 LEFT CORRODED. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-027457.SDR AALA20121217013Skin · corrodedFUSELAGE SKIN FROM STATIONS 947 TO 967 BETWEEN STRINGERS 21 AND 23 LEFT CORRODED. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-027457.SDR AALA20121209005Skin · corrodedFUSELAGE SKIN FROM STATIONS 927 TO 947 BETWEEN STRINGERS 21 AND 23 LEFT CORRODED. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-027457.SDR AALA20121006004Transmitter · faultyLAX INFLIGHT DFW-SNA. CREW REPORTED TRAILING EDGE FLAPS DISAGREE. EMERGENCY DECLARED FLIGHT DIVERTED LAX LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED RIGHT FLAP POSITION TRANSMITTER. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20120404001Lens · brokenFORWARD RIGHT NR 1 DOOR FLOOR EMERGENCY LIGHT LENS BROKEN. REPLACED LIGHT ASSEMBLY FOR FORWARD RIGHT NUMBER 1 DOOR FLOOR EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20111225LGA01Proximity Sensor · inoperativeINFLIGHT. CREW REPORTED ON INITIAL CLIMBOUT, INTERMITTENT WARNING HORN WENT OFF. GEAR AND FLAPS WERE UP. NO LIGHTS. PULLED AURAL WARNING CIRCIT BREAKER TO SILENCE HORN. FLIGHT DIVERTED, LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED S1SDR AALA20110812GSW01Charger · inoperativeONT - INFLIGHT DFW-SNA. CREW REPORTED INTEGRATED STANDBY FLIGHT DISPLAY INOPERATIVE. FLIGHT DIVERTED ONT LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED INTEGRATED STANDBY FLIGHT DISPLAY BATTERY CHARGER. SYSTEM GROUND CHECK NORMAL OPERATISDR AALA20101020TUL03Skin · damagedLEFT INBOARD FLAP UPPER SKIN HAS HOLE WORN THROUGH BONDED REPAIR DOUBLER APPROXIMATELY 18 INCHES FROM OUTBOARD END OF FLAP. LEFT INBOARD FLAP REMOVED DAMAGED SKIN AND INSTALLED BONDED DOUBLER REPAIR PER SRM 51-70-10-2R.SDR AALA20100610DFW01Shroud · damagedSEAT ROW 29 EMERGENCY LIGHT SHROUD DAMAGED. REMOVED AND REPLACED SHROUD FOR SEAT ROW 29 EMERGENCY LIGHT. OPS CHECKED NORMAL.SDR AALA20100604TUL04Seal · obstructedR2 WINDOW SQUEAL/NOISE. CLEARED DEBRIS FROM WINDOW SEAL. PERFORMED PRESSURE CHECK. OPS CHECK OK (NO REPORT).SDR AALA20100629TUL05Battery Pack · dischargedEMERGENCY LIGHTS AT SEAT ROWS 7D THROUGH 12D INOPERATIVE. REPLACED BATTERY PACK.SDR AALA20090720SJU01Seal · damagedMBJ - DURING CRUISE HYDRAULIC SYSTEM A QUANTITY LOST, AFTER LANDING QUANTITY AT 7 PERCENT QUANTITY DURING CRUISE VARIED FROM % 12 - % 20. HYDRAULIC PUMPS NEVER DISPLAYED LESS THAN NORMAL PRESSURE WHEN SWITCHED ON. OPS CHECK PROBE LEAK AT ACOUSTIC FILTER LOWERSDR AALA2009042600001Bracket · brokenMIA - LEFT NUMBER ONE DOOR GIRT BAR BRACKET BROKEN. REPLACED GIRT BAR AND BRACKET FOR LEFT NUMBER ONE DOOR.SDR AALA2009021301028O-Ring · damagedMIA - EMERGENCY DECLARED FOR LOSS OF SYSTEM A HYD LANDED AT MIA WITHOUT INCIDENT. SYSTEM A HYD ELECTRIC ACOUSTIC FILTER ASSEMBLY LEAKING AT TOP ELBOW FITTING. REPLACED O-RING. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA200810162Web · corrodedCORROSION ON WEB STATION 986.5 RBL32 FORWARD OF RIGHT FORWARD OF G4 MOUNT. INSTALLED REPAIRED PER SRM 51-70-13.SDR AALA200810161Floorbeam · corrodedCORROSION ON FLOORBEAM, FRAME 986 AT RBL43. INSTALLED "T" CAP REPAIR PER SRM 53-70-51 FROM RBL2 TO RBL49.SDR AALA200810167Floorbeam · corrodedCORROSION ON FLOOR FRAME. INSTALLED FILLER STRAP AND ANGLES PER SRM 53-00-51.SDR AALA200810166Floorbeam · corrodedCORROSION ON FLOOR FRAME. INSTALL FILLER STRAP AND ANGLES PER SRM 53-00-51.SDR AALA200810165Floorbeam · corrodedCORROSION ON FLOOR FRAME. INSTALLED FILLER STRAP AND ANGLES 1 AND 2.SDR AALA200810164Web · corrodedCORROSION ON FLOOR WEB. INSTALLED DOUBLER PER SRM 51-70-13.SDR AALA200810163Web · corrodedCORROSION ON FLOOR WEB. INSTALLED DOUBLER PER SRM 51-70-13.SDR AALA20081028001Floor Support · corrodedCORROSION ON FLOOR SUPPORT BEAM STATION 970-975 AT LEFT HAND BODY LINE 16.SDR AALA200810152Floorbeam · damagedAFT CARGO FLOORBEAM HAS 2 HOLES DRILLED THROUGH TOP FLANGE AT STATION 787 RIGHT BODY LINE 8.10. BLENDED DAMAGED AREA AND ACCOMPLISHED SPLICE REPAIR PER SRM 53-00-53 IAW ESO 61000 AT STATION 787 AND 788 RIGHT BODY LINE 8.10.SDR AALA200810158Web · corrodedCORROSION ON WEB AT STATION 990. AREA REPAIRED PER SRM 51-70-13-2.SDR AALA200810157Boss · damagedHOLES DRILLED INTO TIE DOWN BOSS. REPLACED THE SECTION OF FLOOR BOARD SUPPORT FROM STATION 727F + 11" TO 727F +10 RBL14 PER SRM 53-00 AND 53-02.
Back to N904AN