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 AALA202403153470Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING BOX FORWARD SPAR UPPER SHEAR FITTING AT BS 540 AND LBL 54.60. REPLACED SHEAR FITTING PER AARD 57-14-00-1 REPAIR 1. THIS ACCOMPLISHES BOEING SB-737-57-1309.SDR AALA202304100468Skin · damagedAIRCRAFT IN BASE MAINTENANCE: SMALL AREA OF DAMAGE ON UPPER SKIN AROUND THE HINGE CUT OUT. LOCATED AT LEFT ELEVATOR TAB AT ELEVATOR STA 24.9. INSTALLED BONDED REPAIR PER EA.SDR AALA202304053023Control Valve · faultyAIRCRAFT WAS GROUNDED: FLAPS SELECTED DOWN AND NO MOVEMENT NOTED. DECLARED AN EMERGENCY AND DIVERTED TO CLT. PERFORMED FLAPS UP LANDING. AIRCRAFT WAS NOT OVERWEIGHT FOR LANDING. **SUPPLEMENTAL REPORT FOR AALA202301113023: REMOVED AND REPLACED TRAILING EDGE FLASDR AALA202301113023Flap System · faultedAIRCRAFT WAS GROUNDED: FLAPS SELECTED DOWN AND NO MOVEMENT NOTED. DECLARED AN EMERGENCY AND DIVERTED TO CLT. PERFORMED FLAPS UP LANDING. AIRCRAFT WAS NOT OVERWEIGHT FOR LANDING. OPEN.SDR AALA202212148401Smoke Detector · no testAFT CARGO A3 SMOKE DETECTOR INOPERATIVE. REPLACED THE SMOKE DETECTOR IAW AMM 26-16-01 AND ACCOMPLISHED A SATISFACTORY OPS TEST IAW AMM 26-16-00-710-801.SDR AALA202212093392Vapor Barrier · crackedAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND MAIN LANDING GEAR WHEEL WELL, WING CENTEER BOX VAPOR BARRIER CRACKED AT RBL 50 AND WL 160. MAINTENANCE REPAIRED VAPOR BARRIER PER SRM 57-10-10-2R-2.SDR AALA202212142634Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR BEAM LOCATED AT BS 986.5 AND LBL 43. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R PROCEDURE 4.SDR AALA202212149639Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FLOOR BEAM LOCATED AT BS 947.5 AND LBL 26. REPAIRED FLOOR BEAM PER SRM 53-70-51-2R-5.SDR AALA202211299318Frame · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED HOLES IN FRAME 986.5 AND RIGHT BUTT LINE 50 STRINGER 17R. REMOVED AND INSTALLED FRAME SECTION PER SRM 51-40-02.SDR AALA202211292285Angle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED ANGLE ON AFT SIDE OF INTERCOSTAL BETWEEN STA 500E - 500F AT STR 25R. INSTALLED CLIP AT STA 500F S-25R PER B737NG SRM 51-40-02.SDR AALA202211290887Support · crackedAIRCRAFT IN BASE MAINTENANCE: AFT CARGO FLOOR SUPPORT ANGLE CRACKED AT STA 867 AND LEFT BUTT LINE 7. REMOVED AND REPLACED SUPPORT PER SRM 51-40-02.SDR AALA202211295275Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN FLOOR SUPPORT CORRODED LOCATED AT STA 993 AND RIGHT BUTT LINE 37. REMOVED AND REPLACED MAIN CABIN FLOOR SUPPORT PER SRM 51-40-02-0G.SDR AALA202211299595Web · corrodedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN FLOOR FITTING ANCHOR WEB CORRODED LOCATED AT STA 998 AND RIGHT BUTT LINE 33. REMOVED AND REPLACED MAIN CABIN FLOOR ANCHOR WEB PER STA 998 AND RIGHT BUTT LINE 33 PER SRM 51-40-02-0G.SDR AALA202211297282Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE: R2 DOOR SILL WEB CORRODED LOCATED AT STA 985-992 RIGHT BUTT LINE 50. REMOVED AND REPLACED R2 DOOR SILL WEB PER SRM 51-40-02-0G.SDR AALA202211299262Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN FLOOR BEAM T-CAP CORRODED LOCATED AT STA 986.5 AND BETWEEN BUTT LINE 0 AND RIGHT BUTT LINE 44. REMOVED AND REPLACED T-CAP PER SRM 53-70-51-2R.SDR AALA202211224192Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN FLOOR SUPPORT LOCATED AT BS 993 AND LBL 36. REPLACED FLOOR SUPPORT PER SRM 51-40-02-0G.SDR AALA202211221718Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN FLOOR WEB LOCATED AT BS 986.5 AND LBL 31. REPLACED WEB PER SRM 51-40-02-0G.SDR AALA202211220470Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 500D TO BS 500I AT S25R. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202211224816Channel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R2 DOOR MOP SILL CORRODED LOCATED FROM BS 947.5 TO BS 986.5 AT RBL 50. REPLACED SILL PER SRM 51-40-02-0G.SDR AALA202211154786Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT RIGHT HAND SIDE BAFFLE UPPER AFT FASTENER HOLE LOCATED FROM BS 500A TO BS 500B AT S25R. REPLACED BAFFLE PER SRM 51-40-02-0G AND SRM 51-40-05-0G.SDR AALA202211157140Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN AFT CARGO COMPARTMENT FLOOR INTERCOSTAL LOCATED AT BS 927 AND S25R. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202211157687Web · damagedAIRCRAFT IN BASE MAINTENANCE: ELONGATED HOLE IN CUSP WEB LOCATED AT BS 290 AND RBL 64. REPLACED WEB PER SRM 51-40-02.SDR AALA202211152647Crease Beam · elongatedAIRCRAFT IN BASE MAINTENANCE: ELONGATED HOLE IN CREASE BEAM LOCATED FROM BS 500G TO BS 500H AT RBL 64. REPAIRED BEAM PER SRM 51-40-02 AND EA 340061.SDR AALA202211153052Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND SIDE CUSP WEB INNER CHORD LOCATED AT BS 639 AND LBL 64. REPLACED CUSP WEB INNER CHORD PER SRM 51-40-02.SDR AALA202211081241Structure · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD PASSENGER CABIN CHORD LOCATED FROM BS 294 TO BS 328, AT RBL 53. REPLACED CHORD PER SRM 51-40-02.SDR AALA202211088741Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT LEFT HAND FLOOR TRANSITION PANEL LOCATED FROM BS 767 TO BS 847 AT S25L. REPLACED TRANSITION PANEL PER SRM 51-40-02.SDR AALA202211086001Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE LOCATED BETWEEN BS 400 AND BS 420 AT S25R. REPLACED BAFFLE PER SRM 51-40-02.SDR AALA202211084114Stringer · wornAIRCRAFT IN BASE MAINTENANCE: WEAR ON S15L LOCATED BETWEEN BS 500G AND BS 500H. REPAIRED STRINGER PER SRM 53-00-03-2R-1.SDR AALA202211087970Stringer · wornAIRCRAFT IN BASE MAINTENANCE: WEAR ON S15L LOCATED BETWEEN BS 500I AND BS 520. REPAIRED STRINGER PER SRM 53-00-03-2R-1.SDR AALA202211290835Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO TRANSITION PANEL BETWEEN STA 727 AND STA 767 AT STR 25L. INSTALLED NEW TRANSITIONAL PANEL AT AFT CARGO PER SRM 51-40-02.SDR AALA202211088481Baffle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON BAFFLE ASSEMBLY LOCATED BETWEEN BS 500F AND BS 500G AT S25R. REPLACED BAFFLE PER SRM 53-30-53 2R1.SDR AALA202211040368Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: AFT CARGO COMPARTMENT RIGHT FLOOR TRANSITION PANEL HAS AREAS OF CORROSION ON UPPER SURFACE BETWEEN STATION 727F AND STATION 787 AND LEFT BUTT LINE 25. REMOVED AND REPLACED TRANSITION PANEL PER SRM 53-00-53-2R-5SDR AALA202211040554Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND AFT FASTENER HOLE ON FLOOR BEAM AT STA 967 AND RIGHT BUT LINE 30. INSTALLED A SPLICE REPAIR PER SRM 53-00-51-2R-1.SDR AALA202211156830Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 500C TO BS 500H AND LBL 25. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G. OPENSDR AALA202211011230Support Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT FLOOR SUPPORT ANGLE LOCATED AT BS 794 AND RBL 13.84. REPAIRED PER SRM 53-00-53-2R-3.SDR AALA202211016830None · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND TRANSITION PANEL LOCATED FROM BS 500C TO BS 500H AND LBL 25. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202211017397None · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 400 TO BS 420 AND RBL 25. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202211148365Structure · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND FORWARD SIDE WEB INNER CHORD LOCATED FROM BS 312 TO BS 344 AT LBL 53. REPLACED CHORD PER SRM 51-40-02-0G.SDR AALA202211017254None · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT RIGHT HAND SIDEWALL CAPSTRIP LOCATED FROM BS 727I TO BS 767 AND FROM S25R TO S26R. REPLACED CAPSTRIP PER AMM 25-52-06.SDR AALA202211018806None · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 420 TO BS 440 AND RBL 40. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202211014233None · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 490 TO BS 500A AND RBL 40. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202210126700Support · corrodedAIRCRAFT IN BASE MAINTENANCE: AFT CARGO FLOOR PANEL LATERAL SUPPORT STRAP LOCATED AT STA 772 LEFT BUTT LINE 14 TO RIGHT BUTT LINE 14 CORRODED. REMOVED AND REPLACED FLOOR PANEL SUPPORT PER SRM 51-40-02-0G.SDR AALA202210100316Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN FLOOR INTERCOSTAL CORRODED LOCATED AT STA 960 AND RIGHT BUTT LINE 47. REMOVED AND REPLACED MAINT CABIN FLOOR INTERCOSTAL STA 960 AND RIGHT BUTT LINE 47 PER SRM 51-40-02-0G.SDR AALA202212238594Cargo Track · corrodedAIRCRAFT IN BASE MAINTENANCE: FORWARD CARGO AFT BULKHEAD LOWER RAIL HAS SIGNS OF CORROSION IN RADIUS LOCATED AT STA 500I AND STR 25R AND 26R. REMOVED AND REPLACED FORWARD CARGO AFT BULKHEAD LOWER RAIL PER B737-NG SRM 51-40-02-0G.SDR AALA202301092840Bulkhead Web · crackedAIRCRAFT IN BASE MAINTENANCE: AFT PRESSURE BULKHEAD WEB ATTACHMENT AT STA 1016 BUTT LINE 17R CRACKED. REMOVED AND REPLACED WEB PER SRM.SDR AALA2020021769010Shade · damagedAIRCRAFT WAS GROUNDED: SEAT ROW 14F EMERGENCY EXIT DOOR WINDOW SHADE AND HANDLE DAMAGED AND PARTIALLY BLOCKING VISIBILTY OF THE WINDOW. REPLACED WINDOW SHADE ASSEMBLY PER AMM 52-22-00.SDR AALA2020012179019Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED INTERCOSTAL BETWEEN BS 344 AND BS 360 AT LBL 12. REPLACED INTERCOSTAL PER 51-00-05-01.SDR AALA2020012179018Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED INTERCOSTAL BETWEEN BS 344 AND BS 360 AT BL 0. REPLACED INTERCOSTAL PER AARD 51-00-05-01.SDR AALA201908159001Smoke Detector · false activationAIRCRAFT NOT GROUNDED, AFT R LAV SMOKE DET WAS TURNED OFF DUE TO FALSE WARNING. REMOVED AND REPLACED SMOKE DETECTOR IN RIGHT AFT LAV IAW AMM 26-14-01. OPS CHECK OK.SDR AALA2018122649006Relay · faultedAFTER TAKEOFF, THE PILOT REPORTED A RUNAWAY STABILIZER TRIM CONDITION. AN EMERGENCY WAS DECLARED, RETURNED TO DEPARTURE, AND LANDED WITHOUT INCIDENT. THE AIRCRAFT WAS GROUNDED. REPLACED THE ELECTRIC TRIM RELAY R-64. OPS CHECKED IAW AMM 22-11-81.
Back to N904AN