N909AN
Service difficulty reports · 216
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 = 'N909AN' 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 = 'N909AN' 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 AALA202502036075Elec Connector · brokenAIRCRAFT IN BASE MAINTENANCE: LEFT SEAT ROWS 13, 15, 20, 22 EMERGENCY LIGHT CONNECTORS BROKEN. REMOVED AND REPLACED LEFT SEAT ROW 13 (AALA202502032824), ROW 15 (AALA202502036075), ROW 20 (AALA202502032328), ROW 22 (AALA202502031304) EMERGENCY LIGHT CONNECTORS.SDR AALA202412195160Sign · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT PLACARD IN THE AISLE ADJACENT TO EMERGENCY EXIT FELL TO THE FLOOR ON TAKEOFF ROLL. RESECURED EMERGENCY EXIT SIGN COVER. PER AMM 33-51-01.SDR AALA202412164242Sign · missingAIRCRAFT WAS NOT GROUNDED: ROW 17 A EMERGENCY ASSY EXIT LIGHT IDENTIFIER MISSING. INSTALLED NEW EXIT LIGHT ASSY.SDR AALA202412163965Brake Assy · seizedAIRCRAFT WAS NOT GROUNDED: AFTER GETTING PUSHED BACK OFF THE GATE TRIED TO TAXI OUT IN THEALLEYWAY. AFTER BRINGING THE THRUST UP TO 40% THE AIRCRAFT WOULD NOT MOVE. WE CALLED OPS AND ASKED FOR A TUG TO COME TO TUG US ABOUT 20 FEET TO GET OUT OF THE RUT. HOWEVESDR AALA202411227508Screw · looseAIRCRAFT WAS NOT GROUNDED: REPORTS OF AFT LEFT LAVATORY DOOR IS DIFFICULT TO OPEN AND CLOSE DUE TO LOOSE SCREW ON UPPER EDGE. RESECURED SCREW LEFT AFT LAVATORY DOOR LAVAVTORY-D. OPERTIONAL CHECK NORMAL. PER CMM 25-40-64.SDR AALA202410100162Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT AT ROW 11 ABC FOUND HANGING. REINSTALLED EMERGENCY LIGHT. LIGHT CHECKS GOOD. PER AMM 33-51-11.SDR AALA202408276145Brake Assy · malfunctionedAIRCRAFT WAS GROUNDED: ON LANDING ROLL OUT WITH ALMOST NO BRAKES BEING APPLIED THE RIGHT BRAKE GRABBED MOMENTARILY. AFTER PARKING A GROUND CREW REPORTED THE RIGHT BRAKE GLOWING RED. POST FLIGHT WALK AROUND SHOWED THAT THE RIGHT INBOARD BRAKE WAS STILL GLOWING SDR AALA202408277598Brake Assy · overtempAIRCRAFT WAS GROUNDED: ON LANDING ROLL OUT WITH ALMOST NO BRAKES BEING APPLIED THE RIGHT BRAKE GRABBED MOMENTARILY. AFTER PARKING A GROUND CREW REPORTED THE RIGHT BRAKE GLOWING RED. POST FLIGHT WALK AROUND SHOWED THAT THE RIGHT INBOARD BRAKE WAS STILL GLOWING SDR AALA202408226145Brake · overheatedAIRCRAFT WAS GROUNDED: ON LANDING ROLL OUT WITH ALMOST NO BRAKES BEING APPLIED THE RIGHT BRAKE GRABBED MOMENTARILY. AFTER PARKING A GROUND CREW REPORTED THE RIGHT BRAKE GLOWING RED. POST FLIGHT WALK AROUND SHOWED THAT THE RIGHT INBOARD BRAKE WAS STILL GLOWING SDR AALA202408191512Door · out of adjustAIRCRAFT WAS NOT GROUNDED: LAVATORY E DOOR IS DIFFICULT TO OPEN AND CLOSE. ADJUSTED LAVATORY E DOOR.SDR AALA202407022953Light · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT FELL OFF OVER ROW 24ABC. SECURED 24ABC EMERGENCY LIGHT ASSEMBLY. PER MM 33-51-11.SDR AALA202406035208Module · leakingAIRCRAFT WAS GROUNDED: AN EMERGENCY WAS DECLARED DUE TO: FLIGHT CONTROL SYSTEM- A LOW PRESSUREMLIGHT ILLUMINATED; AIRCRAFT AIR INTERRUPTED BACK TO AND LANDED SAFELY AT DFW. REMOVED AND REPLACED SYSTEM-A FLIGHT CONTROL HYDRAULIC MODULE. OPERTIONAL AND LEAK CHECSDR AALA202405150072Door · bindingAIRCRAFT WAS NOT GROUNDED: RIGHT AFT LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. RESECURED DOOR SIL, OPERTIONAL CHECK GOOD. PER SRM 51-40-00.SDR AALA202405130072Door · stiffAIRCRAFT WAS NOT GROUNDED: RIGHT AFT LAVATORY DOOR DIFFICULT TO OPEN AND CLOSE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED**(OPEN).SDR AALA202401299943Girt Bar · lack of lubeAIRCRAFT WAS NOT GROUNDED: RIGHT FORWARD SERVICE DOOR GIRT BAR DIFFICULT TO PULL FROM UNARMED TO ARMED POSITION. ACCOMPLISHED LUBRICATION AND CLEANED GIRT BAR SLIDE FLOOR ARMING MECHANISM. PER AMM 25-66-01.SDR AALA202308215656Flashlight · no testAIRCRAFT IN BASE MAINTENANCE: RIGHT AFT OUTBOARD FLIGHT ATTENDANT'S FLASHLIGHT DOESN'T TEST. REMOVED AND REPLACED RIGHT AFT OUTBOARD FLIGHT ATTENDANT FLASHLIGHT PER B737NG SRM 51-40-02.SDR AALA202308154399Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON VERTICAL STABILIZER RIGHT HAND FAILSAFE FITTING LOCATED AT BS 1088, S2R. REPLACED FITTING PER SRM 51-40-02.SDR AALA202308157476Fitting · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON VERTICAL STABILIZER RIGHT HAND AFT FAILSAFE FITTING LOCATED AT BS 1088, S2R. REPLACED FITTING PER SRM 51-40-02.SDR AALA202308150006Spar · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT HAND STABILIZER REAR SPAR, AROUND FASTENER HOLES LOCATED FROM STAB STA 66.54 TO STAB STA 176.64. REPAIRED SPAR PER EA 344885.SDR AALA202308148727Bulb · burned outAIRCRAFT IN BASE MAINTENANCE: R2 DOOR EXTERIOR EMERGENCY SLIDE LIGHT BURNED OUT. MAINTENANCE FOUND BULB BURNED OUT AND CONNECTOR D11084 DISCONNECTED. REPLACED BULB (AALA202308148727) AND RECONNECTED CONNECTOR PER SWPM 20-61-28 (AALA202308142530). ACCOMPLISHED SDR AALA202308142530Connector · disconnectedAIRCRAFT IN BASE MAINTENANCE: R2 DOOR EXTERIOR EMERGENCY SLIDE LIGHT BURNED OUT. MAINTENANCE FOUND BULB BURNED OUT AND CONNECTOR D11084 DISCONNECTED. REPLACED BULB (AALA202308148727) AND RECONNECTED CONNECTOR PER SWPM 20-61-28 (AALA202308142530). ACCOMPLISHED SDR AALA202308146579Bulb · burned outAIRCRAFT IN BASE MAINTENANCE: RIGHT HAND AFT EXTERIOR OVERWING SLIDE EMERGENCY EXIT LIGHT BULB BURNT OUT. REPLACED BULB AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-04-960-801.SDR AALA202308079406Spar · corrodedAIRCRAFT IN BASE MAINTENANCE CORROSION ON LEFT HAND HORIZONTAL STABILIZER TRAILING EDGE AFT SPAR LOWER CHORD (BEAM) FASTENER ON NUT PLATE HOLES BETWEEN STABILIZER STATIONS 57.99 AND 221.5. REPAIRED CHORD PER EA 344990.SDR AALA202308023703Spring · crackedAIRCRAFT IN BASE MAINTENANCE: UPON REMOVAL OF VERTICAL STABILIZER FOUND ON STABILIZER AFT LOWER SPRING CRACKED AT BS 1016, BETWEEN S2L AND S2R. REPLACED SPRING PER SRM 51-40-02.SDR AALA202308086112Spar · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND HORIZONTAL STABILIZER REAR SPAR LOWER SURFACE FASTENER HOLES BETWEEN STABILIZER STATIONS 44.38 AND 304.19. REPAIRED SPAR PER EA 344990.SDR AALA202308073341Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT SIDEWALL TO BULKHEAD RIGHT HAND ACCESSS PANEL SUPPORT FASTENER HOLES AT BS.947.5 AND RBL 22.5 AND S26R. REPLACED SUPPORT PER SRM 51-40-02.SDR AALA202308078017Angle · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON RIGHT WING UPPER TRAILING EDGE BLADE SEAL RETAINER ANGLE AT WS 405.50 AND RIB 13. REPLACED RETAINER ANGLE PER SRM 51-40-02.SDR AALA202307275726Cargo Track · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND FASTENER HOLES IN AFT CARGO COMPARTMENT FLOOR STRUCTURE CARGO TRACK-TIE DOWN RAIL LOCATED BETWEEN BS 795 AND BS 847 AT RBL 13.84. REMOVED AND REPLACED TIE-DOWN RAIL PER SRM 53-00-53-2R PROCEDURE 4 REPAIR 4.SDR AALA202307188466Rib · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND HORIZONTAL STABILIZER RIB LOCATED AFT OF REAR SPAR AT ELEVATOR STA 66.54. REPAIRED RIB PER EA 344844 AND SRM 51-40-02.SDR AALA202307184436Frame · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT SIDE OF FRAME LOCATED AT BS 947.5 BETWEEN S22R AND S23R. REPAIRED FRAME PER EA 345938 AND SRM 53-70-02-2R.SDR AALA202307170765Skin · corrodedAIRCRAFT IN BASE MAINTENANCE: FUSELAGE SKIN RIGHT DRAIN RECEPTACLE HAS CORROSION AT BS 727E BETWEEN S26R AND 27R. REPAIRED SKIN PER SRM 53-60-01-2R AND EA 345943SDR AALA202307057255Frame · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT MAIN FRAME FORWARD SIDE LOCATED AT BS 927 FROM S20R TO S22R. REPAIRED FRAME PER EA EA345591.SDR AALA202307054953Fitting · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN CENTER WING SPAR SHEAR FITTING LOCATED AT BS 545 AND RBL12. REPLACED SHEAR FITTING PER AARD 57-14-00-1.SDR AALA202306277036Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER RIB, THIRD STIFFENER LOCATED AT STAB STA 111.10. REPLACED RIB PER SRM 51-40-02-0G.SDR AALA202306277556Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER RIB, THIRD STIFFENER LOCATED AT STAB STA 111.10. REPLACED RIB PER SRM 51-40-02-0G.SDR AALA202306232922Web · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN AFT PRESSURE BULKHEAD LOWER WEB LOCATED AT BS 1016 FROM RBL 16.73 TO RBL 8.39. REMOVED, FABRICATED AND INSTALLED NEW WEB PER SRM 51-40-02.SDR AALA202306231398Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND SIDE WALL TRANSITION PANEL LOCATED FROM BS 500A TO BS 500D + 10 INCHES, AT S25R. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R PROCEDURE 5.SDR AALA202310122374Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND SIDE WALL TRANSITION PANEL LOCATED FROM BS 400 TO BS 420 AT S25R. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G. SUPPLEMENTAL REPORT FOR AALA202306232374: QC REVIEWED THIS EVENT ANSDR AALA202306231165Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND SIDE WALL TRANSITION PANEL LOCATED FROM BS 420 TO BS 440 AT S25R. REMOVED, FABRICATED, AND INSTALLED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202306232374Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND SIDE WALL TRANSITION PANEL LOCATED FROM BS 400 TO BS 420 AT S25R. REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.SDR AALA202306233952Unknown · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON MAIN CABIN LEFT HAND MOP SILL (INNER CHORD) LOCATED AT BS 640 AND LBL 64. REMOVED, FABRICATED, AND INSTALLED MOP SILL PER SRM 51-40-02-0G.SDR AALA202306235131Rib · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN LEFT HAND HORIZONTAL STABILIZER RIB LOCATED AFT OF REAR SPAR AT EL STA 24.90. REMOVED, FABRICATED, AND INSTALLED RIB PER SRM 51-40-02-0G AND EA344629.SDR AALA202306288462Rib · corrodedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND HORIZONTAL STABILIZER RIB AFT OF REAR SPAR AT ELEVATOR STATION 24.90 HAS CORRODED FASTENER HOLES. REPAIRED RIB PER EA 344629.SDR AALA202306232019Bulkhead Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PRESSURE BULKHEAD LOWER WEB LOCATED AT BS 1026 FROM RBL 27 TO RBL 47. REMOVED, FABRICATED, AND INSTALLED WEB PER SRM 51-40-02-0G.SDR AALA202306211409Rail · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON CARGO COMPARTMENT AFT BULKHEAD RAIL ASSEMBLY LOCATED AT BS 500I FROM S24R TO S24L. REPLACED RAIL ASSEMBLY PER SRM 51-40-02.SDR AALA202306212625Baffle · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT BAFFLE LOCATED FROM BS 500H TO BS 500G AT S25L. REPLACED BAFFLE PER AARD 20-00-00-1.SDR AALA202306195207Channel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION AROUND FASTENERS HOLES ON AFT CARGO COMPARTMENT LEFT HAND FLOOR STRUCTURE ZEE CHANNEL SIDEPLATE SECTION LOCATED BETWEEN BS 727I AND BS 795 FROM S25L TO S26L. REMOVED, FABRICATED, AND INSTALLED ZEE CHANNEL RE SRM 51-40-02SDR AALA202306190997Skin · wornAIRCRAFT IN BASE MAINTENANCE: FUSELAGE SKIN FOR EXTERNAL POWER DOOR CUTOUT HAS WEAR DAMAGE AT LOWER AREA, LOCATED FROM BS 224 TO BS 235 AT S19R. REPAIRED SKIN PER SRM 53-10-15-2R-4.SDR AALA202306167290Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT LEFT HAND SIDE WALL TRANSITION PANEL LOCATED FROM BS 500 TO BS 500I AT S25R. REPLACED TRANSITION PANEL PER AARD 51-00-05-1 REPAIR 1.SDR AALA202306147775Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND SIDE WALL TRANSITION PANEL LOCATED FROM BS 492 TO BS 500A AT S25R. REMOVED, FABRICATED, HEAT TREATED, AND REPLACED TRANSITION PANEL PER SRM 51-40-02-0G.
Back to N909AN