N930AN
Service difficulty reports · 199
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 = 'N930AN' 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 = 'N930AN' 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 AALA202311280732Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR TRANSITION PANEL UPPER SURFACE AT BS 500A, LBL 24. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202311282150Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT FLOOR TRANSITION PANEL UPPER SURFACE AT BS 500H, LBL 24. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R-5.SDR AALA202311285404Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT CARGO COMPARTMENT TRANSITION PANEL BETWEEN BS 727I AND BS 787, AND BETWEEN S25L AND S26L. REPAIRED TRANSITION PANEL PER SRM 53-00-53-2R.SDR AALA202311286899Floorbeam · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON UPPER CHORD OF FLOOR BEAM AT BS 328, RBL 30. REPAIRED FLOOR BEAM UPPER CHORD PER SRM 53-10-51-2R-7.SDR AALA202311160423Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: 1.5 INCH CRACKED ON MAIN DECK FLOOR SUPPORT AT AIRCRAFT STA 540 AND LBL 3. INSTALLED NEW MAIN DECK FLOOR SUPPORT (143A5240-35SD). PER B737 NG SRM 51-40-02-0G.SDR AALA202311139737Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL BETWEEN STA 947 AND STA 967 AT LBL 24. REPLACED INTERCOSTAL PER SRM 51-40-02 OG.SDR AALA202311134400Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL BETWEEN STA 947 AND STA 961 AT RBL 25. REPLACED INTERCOSTAL PER SRM 51-40-02 OG.SDR AALA202311138286Mount · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT LEFT LAVATORY INBOARD AFT MOUNT AT BS 947.5, LBL 45. REPAIRED FLOOR BEAM UPPER CHORD PER SRM 53-70-51-2R.SDR AALA202311091255Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT GALLEY FLOOR MOUNT INTERCOSTAL FROM BS 947 TO BS 961, RBL 51. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202311066248Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL FROM BS 382 TO BS 344, LBL 46. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202311069900Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL FROM BS 312 TO BS 328, LBL 46. REPLACED INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202308025411Light · brokenAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT AT 27C BROKEN. REPLACED LIGHT ASSEMBLY PER AMM 33-51-00.SDR AALA202207087537Release System · out of positionAIRCRAFT WAS NOT GROUNDED: RIGHT SERVICE DOOR GIRT BAR PLASTIC COVER FELL OFF. INSTALLED NEW RELEASE STOP ASSEMBLY AS PER AMM 25-66-01.SDR AALA202206078574Cap · missingAIRCRAFT WAS NOT GROUNDED: AFT HINGE CAP MISSING FROM 4L DOOR GIRT BAR. REPLACED STOP CAP TO 4L DOOR GIRT BAR.SDR AALA202205279099Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED INTERCOSTAL FLOOR SUPPORT AT STA 540 BUTT LINE 0 TO LEFT BUTT LINE 2. REMOVED AND REPLACED INTERCOSTAL PER SRM 51-40-02-0G,SDR AALA202205276042Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED FLOOR SUPPORT INTERCOSTAL BETWEEN BUTT LINE 0 TO RIGHT BUTT LINE 2. REMOVED AND REPLACED FLOOR SUPPORT INTERCOSTAL PER SRM 51-40-02-0G.SDR AALA202205271580Seat Track · damagedAIRCRAFT IN BASE MAINTENANCE: AIRCRAFT IN BASE MAINTENANCE: MAIN CABIN SEAT TRACK AT STA 521 RIGHT BUTT LINE 24.75 HAS DAMAGE. PERFORMED SPLICE REPAIR ON SEAT TRACK PER 53-00-52--2R.SDR AALA202205278074Seat Track · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN SEAT TRACK AT STA 521 RIGHT BUTT LINE 45.5 HAS DAMAGE. PERFORMED SPLICE REPAIR TO SEAT TRACK PER SRM 53-00-52-2R.SDR AALA202205273385Seat Track · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN SEAT TRACK AT STA 521 LEFT BUTT LINE 24.75 HAS DAMAGE. REPAIRED SEAT TRACK PER SRM 53-00-52-2R.SDR AALA202205272543Seat Track · damagedAIRCRAFT IN BASE MAINTENANCE: MAIN CABIN SEAT TRACK AT STA 521 AND LEFT BUTT LINE 45.5 HAS A LIMITED TIME REPAIR. REPAIRED SEAT TRACK WITH SPLICE PER SRM 53-00-52-2R.SDR AALA202205260920Fitting · noneAIRCRAFT IN BASE MAINTENANCE: L1 DOOR AFT GIRT BAR FITTING NEEDS EDGE SEALED. APPLIED EDGE SEALANT PER AMM-51-31-00-390-804.SDR AALA202205267138Fitting · noneAIRCRAFT IN BASE MAINTENANCE: L1 DOOR FORWARD GIRT BAR FITTING NEEDS EDGE SEALED. APPLIED EDGE SEALANT PER AMM-51-31-00-390-804.SDR AALA202205265122Fitting · noneAIRCRAFT IN BASE MAINTENANCE: R1 DOOR FORWARD GIRT BAR FITTING NEEDS EDGE SEALED. APPLIED EDGE SEALANT PER AMM-51-31-00-390-804.SDR AALA202205264072Fitting · noneAIRCRAFT IN BASE MAINTENANCE: R1 DOOR AFT GIRT BAR FITTING NEEDS EDGE SEALED. APPLIED EDGE SEALANT PER AMM-51-31-00-390-804.SDR AALA202205262514Connector · not seatedAIRCRAFT IN BASE MAINTENANCE: WHILE PERFORMING THE EMERGENCY LIGHT TEST, THE LOWER RIGHT OVER WING EXIT SIGN FAILED TO ILLUMINATE. TIGHTENED CONNECTOR D12066 AT SIGN. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-00 AND WDM 33-51-21.SDR AALA202205261918Skin · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HORIZONTAL STABILIZER LOWER SKIN AT STA 129.50 CRACKED. INSTALLED DOUBLER PER SRM 51-40-02-0G AND SRM 55-10-01-2R-11 REPETITIVE INSPECTION TO BE ACCOMPLISHED NO LATER THAN EVERY 9000 FLIGHT CYCLE. FINAL RESTORATION TO BE ACCOSDR AALA202204061918Skin · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HORIZONTAL STABILIZER LOWER SKIN AT STA 129.50 CRACKED. INSTALLED DOUBLER PER SRM 51-40-02-0G AND SRM 55-10-01-2R-11 REPETITIVE INSPECTION TO BE ACCOMPLISHED NO LATER THAN EVERY 9000 FLIGHT CYCLE. FINAL RESTORATION TO BE ACCOSDR AALA202204074718Skin · crackedAIRCRAFT IN BASE MAINTENANCE: LEFT HAND STABILIZER LOWER SKIN CRACKED AT STABILIZER STATION 129.50 AT THE SIXTH DRAIN HOLE OUTBOARD. REPAIRED SKIN PER SRM 55-10-01-2R-11.SDR AALA202202175126Fuse · blownAIRCRAFT IN BASE MAINTENANCE: EMERGENCY SEAT PROXIMITY LIGHTS INOPERATIVE AT RH ROWS 16-21. REPLACED FUSE WITH NEW IN M1671 BATTERY PACK CHARGER IAW AMM B737-NG 33-51-06, OPS CHECK GOOD.SDR AALA202202072218Smoke Detector · false activationAIRCRAFT IN BASE MAINTENANCE: FORWARD LAVATORY SMOKE DETECTOR ACTIVATED IN FLIGHT, NO SMOKE OR FIRE PRESENT. REPLACED SMOKE DETECTOR PER AMM 26-14-00-730-801.SDR AALA202202231340Attach Fitting · gougedAIRCRAFT IN BASE MAINTENANCE: GOUGE IN OUTBD ATTACH FITTING OF LH ELEVATOR CONTROL TAB MECHANISM FROM PREVIOUSLY INSTALLED FASTENER AT STA 36.4, MEASURING D=0.012 IN. REPLACED FITTING WITH NEW IAW B737-NG SRM 55-20-90-1A.SDR AALA202201283886Sliding Window · out of adjustAIRCRAFT IN BASE MAINTENANCE: R2 SLIDING WINDOW HANDLE HARD TO CLOSE. ADJUSTED SLIDING WINDOW PER CMM 56-10-02.SDR AALA202202278734Battery · missingAIRCRAFT IN BASE MAINTENANCE: QTY 6 EMERGENCY BATTERIES MISSING. INSTALLED QTY 6 BATTERIES (AALA202202268464, AALA202202264618, AALA202202269366, AALA202202261510, AALA202202262783) IAW AMM 33-51-06-960-806, OPS CHECK GOOD.SDR AALA202202278464Battery · missingAIRCRAFT IN BASE MAINTENANCE: QTY 6 EMERGENCY BATTERIES MISSING. INSTALLED QTY 6 BATTERIES (AALA202202268734, AALA202202264618, AALA202202269366, AALA202202261510, AALA202202262783) IAW AMM 33-51-06-960-806, OPS CHECK GOOD.SDR AALA202202274618Battery · missingAIRCRAFT IN BASE MAINTENANCE: QTY 6 EMERGENCY BATTERIES MISSING. INSTALLED QTY 6 BATTERIES (AALA202202268734, AALA202202268464, AALA202202269366, AALA202202261510, AALA202202262783) IAW AMM 33-51-06-960-806, OPS CHECK GOOD.SDR AALA202202279366Battery · missingAIRCRAFT IN BASE MAINTENANCE: QTY 6 EMERGENCY BATTERIES MISSING. INSTALLED QTY 6 BATTERIES (AALA202202268734, AALA202202268464, AALA202202264618, AALA202202261510, AALA202202262783) IAW AMM 33-51-06-960-806, OPS CHECK GOOD.SDR AALA202202271510Battery · missingAIRCRAFT IN BASE MAINTENANCE: QTY 6 EMERGENCY BATTERIES MISSING. INSTALLED QTY 6 BATTERIES (AALA202202268734, AALA202202268464, AALA202202264618, AALA202202269366, AALA202202262783) IAW AMM 33-51-06-960-806, OPS CHECK GOOD.SDR AALA202202272783Battery · missingAIRCRAFT IN BASE MAINTENANCE: QTY 6 EMERGENCY BATTERIES MISSING. INSTALLED QTY 6 BATTERIES (AALA202202268734, AALA202202268464, AALA202202264618, AALA202202269366, AALA202202261510) IAW AMM 33-51-06-960-806, OPS CHECK GOOD.SDR AALA202008249003Light · inoperativeAIRCRAFT WAS NOT GROUNDED: EXIT PATH LIGHTING IN FIRST CLASS OPPOSITE FIGHT ATTENDANT SUPPLY CLOSET IS INOPERATIVE. REPLACED LIGHT ASSEMBLY. OPERATIONS CHECK OK PER AMM 33-51-00.SDR AALA202007179018Pump · low pressureAIRCRAFT WAS GROUNDED: LEFT AFT FUEL PUMP LOW PRESSURE LIGHT ILLUMINATED AFTER TAKEOFF. REPLACED LEFT AFT BOOST PUMP AND ACCOMPLISHED A SATISFACTORY LEAK / OPERATIONAL CHECK IAW AMM 28-22-41.SDR AALA201911259024Transceiver · unreliableAIRCRAFT WAS GROUNDED: PILOT REJECTED TAKE OFF AT 90 KTS DUE TO PREDICTIVE WINDSHEAR WARNING. RADAR CONTINUED TO DISPLAY WX OF HIGH INTENSITY EVEN THOUGH WX WAS ACTUALLY NOT PRESENT. 153,0000 T/O WEIGHT. MAINTENANCE REMOVED & REPLACED WXR UNIT IAW AMM 34-43-00SDR AALA201908019004Slide · faultyAIRCRAFT WAS NOT GROUNDED: FLIGHT ATTENDANT REPORTED TOO MUCH MATERIAL HANGING FROM SLIDE PACK AT AFT RIGHT HAND DOOR. MAINTENANCE RESTOWED EXCESS MATERIAL FROM DOOR SLIDE PER AMM 25-66-00.SDR AALA201905149012Hose · leakingAIRCRAFT WAS GROUNDED: PILOT REPORTS DURING PREFLIGHT GROUND CREW INFORMED F/O OF BROWN FLUID LEAKING FROM CEILING OF FORWARD CARGO. MAINTENANCE FOUND WATER LEAK IN FWD CARGO. AFT GREY WATER HOSE. REMOVED AND REPLACED AFT GREY WATER HOSE IAW AMM 38-31-00. OPS SDR AALA2018071869044Megaphone · inoperativeAFT CABIN MEGAPHONE WAS FOUND INOPERATIVE. REPLACED THE MEGAPHONE IAW AMM 25-64-00.SDR AALA20171124003Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION IN 3 SMALL AREAS OF FLOORBOARD SUPPORT STA 951 TO STA 961 AT RIGHT BUTTLINE 50 INCHES. REPLACED FLOORBOARD SUPPORT PER AARD 51-00-05-1 AND DRAWING 815A0010.SDR AALA20171124002Floor Support · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION OF FLOORBOARD SUPPORT AROUND 2 NUT PLATE HOLES TO THE UPPER AND LOWER SURFACE OF FLANGE AT STA 952 RIGHT BUTTLINE 27 INCHES TO RIGHT BUTTLINE 32 INCHES. INSTALLED NEW FLOORBOARD SUPPORT PER AARD 51-00-05-1 AND DRAWING 81SDR AALA20171121002Floor Support · crackedCRACKED FLOOR SUPPORT BETWEEN BS 328 AND 344, LBL 45. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1, AND DRAWING 141A5400.SDR AALA20171121001Floor Support · crackedCRACKED FLOOR SUPPORT BETWEEN BS 312 AND 328, LBL 45. REPAIRED THE FLOOR SUPPORT IAW 51-00-05-1 AND DRAWING 141A5400.SDR AALA20171115012Angle · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION FOUND ON Z ANGLE AT STATION 986. INSTALLED NEW Z ANGLE PER 51-00-05-1.SDR AALA20171115008Stringer · crackedAIRCRAFT IN BASE MAINTENANCE. FORWARD CARGO STRINGER CRACKED IN BOTTOM OF RADIUS AT STATION 500F AND STRINGER 23L. INSTALLED NEW SECTION OF STRINGER PER SRM 53-00-03-2R-1.
Back to N930AN