N923AN
Service difficulty reports · 171
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 = 'N923AN' 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 = 'N923AN' 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 AALA20170121004Floorbeam · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. CABIN FLOORBEAM AT FUSELAGE STATION 986 HAS CORROSION AROUND FASTENER HOLES BETWEEN RBL 4 AND RBL 32. REPAIRED FLOORBEAM IAW SRM 53-70-51-2R-4.SDR AALA20170118034Angle · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. RIGHT CREASE ANGLE IS CORRODED BETWEEN APPROXIMATELY FUSELAGE STATION 957 AND BETWEEN STATIONS 967 AND 986. REMOVED AND REPLACED CREASE ANGLE IAW AARD 51-00-05 AND DRAWING 147A8501.SDR AALA20170117010Floor Support · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. AFT CARGO COMPARTMENT FLOOR SUPPORT AT LBL 3 IS CORRODED BETWEEN FUSELAGE STATIONS 727 AND 727A. REPAIRED SUPPORT BETWEEN STATIONS 727 AND 727B +10 INCHES IAW SRM 51-10-02-0G AND SRM 53-00-53-2R-2.SDR AALA20170117007Floor Support · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. AFT CARGO COMPARTMENT FLOOR SUPPORT AT RBL 14 IS CORRODED BETWEEN FUSELAGE STATIONS 787 AND 847. REPAIRED FLOOR SUPPORT BETWEEN STATIONS 765 AND 867 IAW SRM 51-10-02-0G AND SRM 53-00-53-2R.SDR AALA20170117006Floor Support · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. AFT CARGO COMPARTMENT FLOOR SUPPORT AT LBL 17.2 IS CORRODED BETWEEN FUSELAGE STATIONS 727 AND 727A. REPAIRED SUPPORT BETWEEN STATIONS 727 AND 727B + 10 INCHES IAW SRM 51-10-02-0G AND SRM 53-00-53-R2-3.SDR AALA20170116003Strap · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. AFT CARGO COMPARTMENT DOOR CUTOUT THRESHOLD HAS SEVERAL AREAS OF CORROSION BETWEEN FUSELAGE STATIONS 787 AND 847. REMOVED AND REPLACED THRESHOLD WEB STRAP IAW SRM 51-40-02, DRAWING 146A8120 AND EA 266665.SDR AALA20170124024Floor Support · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. AFT CARGO COMPARTMENT FLOOR SUPPORT AT RBL 8 IS CORRODED BETWEEN FUSELAGE STATIONS 767 AND 787. REPAIRED SUPPORT IAW AND SRM 53-00-53-2R-2 AND EA 266588.SDR AALA20170113040Floor Support · corrodedLIGHT CORROSION ON CARGO FLOOR SUPPORTS, STA 767-787, RBL 8, LBL 8. INSTALLED FLOOR SUPPORT RAIL SPLICES AT STA 767-787 RBL 8 AND LBL 8 PER EA 266588 AND SRM 53-00-53-2R-2SDR AALA20170113039Floor Support · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. AFT CARGO COMPARTMENT FLOOR SUPPORT AT RBL 8 IS CORRODED BETWEEN FUSELAGE STATIONS 727I AND 727J. REMOVED AND REPLACED SUPPORT IAW EA 266251 AND SRM 53-00-53-2R-2.SDR AALA20170111032Angle · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. AFT CARGO COMPARTMENT RIGHT TRANSITION ANGLE IS CORRODED BETWEEN FUSELAGE STATIONS 727C AND 767. REMOVED AND REPLACED TRANSITION ANGLE BETWEEN STATIONS 727C AND 767 IAW SRM 51-10-02-0G AND SRM 53-00-53-2R-5.SDR AALA20170111007Rib · crackedAIRCRAFT WAS IN BASE MAINTENANCE. LEFT HORIZONTAL STABILIZER RIB AT STABILIZER STATION 92.7 IS CRACKED AT STIFFENERS 1, 2 AND 3. REPAIRED RIB IAW SRM 55-10-09-2R-4.SDR AALA20170111005Rib · crackedAIRCRAFT WAS IN BASE MAINTENANCE. RIGHT HORIZONTAL STABILIZER RIB AT STABILIZER STATION 92.7 IS CRACKED AT THE 2, 3 AND 4 STIFFENER LOCATIONS. REPAIRED RIB IAW SRM 55-10-09-2R-4 AND EA 266277.SDR AALA20170109017Support Angle · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. FORWARD CARGO COMPARTMENT SUPPORT ANGLE AT FUSELAGE STATION 500I BETWEEN LBL 24 AND RBL 25 IS CORRODED. REMOVED AND REPLACED SUPPORT ANGLE IAW AARD 51-00-05.SDR AALA20170109006Baffle · crackedAIRCRAFT WAS IN BASE MAINTENANCE. FORWARD CARGO COMPARTMENT BAFFLE BETWEEN FUSELAGE STATIONS 500C AND 500D ON RIGHT CRACKED ON LOWER SIDE. REMOVED AND REPLACED BAFFLE IAW AARD 51-00-05-1SDR AALA20170108007Angle · corrodedAIRCRAFT IS IN BASE MAINTENANCE. AFT CARGO COMPARTMENT LEFT TRANSITION ANGLE IS CRACKED AT FUSELAGE STATION 747 AND CORRODED BETWEEN STATIONS 727J TO 787. REMOVED AND REPLACED TRANSITION ANGLE BETWEEN STATIONS 727J AND 847 IAW SRM 51-10-02-0G AND SRM 53-00-53-SDR AALA20170107005Floor Support · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. AFT CARGO COMPARTMENT FLOOR SUPPORT AT RBL 14 IS CORRODED BETWEEN FUSELAGE STATIONS 727 AND 727A. REMOVED AND REPLACED FLOOR SUPPORT BETWEEN STATIONS 727 AND 727F +6 INCHES IAW SRM 51-10-02-0G AND SRM 53-00-53-2RSDR AALA20170104005Angle · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. FORWARD CARGO COMPARTMENT LEFT TRANSITION ANGLE IS CORRODED BETWEEN FUSELAGE STATIONS 450 AND 500I. REMOVED AND REPLACED TRANSITION ANGLE SECTIONS BETWEEN STATIONS 450 AND 500I IAW AARD 51-00-05 AND SRM 53-00-05-2R PROCEDURE 5SDR AALA20170104004Angle · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. FORWARD CARGO COMPARTMENT RIGHT TRANSITION ANGLE IS CORRODED BETWEEN FUSELAGE STATIONS 490 AND 500I. REMOVED AND REPLACED TRANSITION ANGLE SECTIONS BETWEEN STATIONS 490 AND 500I IAW AARD 51-00-05 AND SRM 53-00-05-2R PROCEDURE SDR AALA20161222014Floor Support · crackedCRACK ON CABIN FLOOR SUPPORT AT BS 540 AND RBL 0. REPLACED THE FLOOR SUPPORT IAW 51-00-05-01.SDR AALA20161222013Floor Support · crackedCRACK ON CABIN FLOOR SUPPORT AT BS 540 AND LBL 0. REPLACED FLOOR SUPPORT IAW 51-00-05-01.SDR AALA20161222012Floor Support · crackedCRACK ON CABIN FLOOR SUPPORT AT BS 312-328 AND LBL46. REPLACED THE FLOOR SUPPORT IAW 51-00-05-01.SDR AALA20161222011Floor Support · crackedCRACK ON CABIN FLOOR SUPPORT AT BS 328-344 AND LBL46. REPLACED THE FLOOR SUPPORT IAW 51-00-05-01.SDR AALA20161222010Floor Support · crackedCRACK ON CABIN FLOOR SUPPORT AT STATION 312-328 AND RBL 31. REPLACED THE FLOOR SUPPORT IAW 51-00-05-1.SDR AALA20160617008Window · noisyAIRCRAFT WAS GROUNDED, AIR INTERRUPT, EMERGENCY DECLARED, LANDING UNEVENTFUL. DURING CLIMB THROUGH 16,000 FT THE CAPTAIN"S SLIDING WINDOW BEGAN TO SQUEAL LOUDLY. SQUEAL STOPPED DURING DESCENT THROUGH 7,000 FT. MAINTENANCE INSPECTED CAPTAIN"S SLIDING WINDOW SDR AALA20160307003Light · brokenAFT GALLEY DOOR EMER EXIT LIGHT FOUND BROKEN AT GATE PRIOR TO DEPARTURE. REPLACED RT AFT DOOR EMER EXIT LIGHT ASSEMBLY IAW AMM 33-51-01, CHECKED GOOD. LT ASSEMBLY TRASH DOOR. THE ACFT WAS NOT GNDED.SDR AALA20151001001Bulkhead · crackedBULKHEAD WEB AT FS 633.75 HAS MULTIPLE CRACKS, BETWEEN LBL 31 & RBL 40. INSTALLED DOUBLER REPAIRS IAW EA 254988. PREVIOUS REPAIRS WERE REMOVED AND REPLACED WITH PERMANENT REPAIRS IAW SRM 57-10-10-2R-3 ALTERATIVE 2 AND EA 226134. (CLOSED)SDR AALA20150914011Pump · failedB SYS HYD PRESSURE & QTY LOSS. EMERGENCY WAS DECLARED, AND AN UNEVENTFUL LANDING. R & R RT ENGINE HYD PUMP. PERFORMED OPS & LEAK CHECK IAW AMM 29-11-11. ACCOMPLISHED HYD SYS FLUSHING IAW MCM CARD 29-93-01.SDR AALA20150913009Pump · leakingEMERGENCY DECLARED, LANDING UNEVENTFUL & ACFT NOT OVERWEIGHT. DURING CRUISE SYS B NR 2 ENG HYD PUMP LOW PRESS LIGHT ILLUMINATED & QTY DROPPED TO ZERO. FOUND NR 2 ENG DRIVEN PUMP LEAKING OUT OF SHAFT. R & R PUMP IAW AMM 29-11-11.SDR AALA20150305004Skin · corrodedLEFT WING SKIN CORRODED AT FS 540 & DRAG LINK LOCATION. REPAIRED SKIN IAW EA 57-038841.SDR AALA20141221005Seal · damagedDURING CRUISE FLIGHT ATTENDANT REPORTED LOUD SQUEAL FOR L1 DOOR. INTERFERED WITH FLIGHT ATTENDANT DUTIES. DIVERTED, EMERGENCY NOT DECLARED, AND LANDED UNEVENTFULLY. FOUND LOWER DOOR HINGE COVER SPRING DAMAGED. REMOVED AND REPLACED L1 DOOR SEAL IAW AMM 52-SDR AALA20141127003Pitot Tube · defectiveDURING CLIMB CAPTAIN`S PITOT HEAT WARNING ILLUMINATED & REMAINED ON. AIR INTERRUPTION, DIVERTED, EMERGENCY NOT DECLARED & LANDING UNEVENTFUL. REMOVED AND REPLACED CAPTAIN`S PITOT PROBE IAW AMM 34-11-01-000-801. SYSTEM CHECKED NORMAL.SDR AALA20141101008Warning System · false activationAIR INTERRUPT IN CRUISE, RT & LT CTR FUEL TANK BOOST PUMPS LOW PRESS LIGHT ILLUMINATED. DIVERTED, EMER DECLARED, LANDING WAS UNEVENTFUL & ACFT NOT OVERWEIGHT. ACCOMPLISHED UFI CHECK, NO FAULTS FOUND. ACCOMPLISHED OPERATIONS CHECK OF BOTH CTR TANK BOOST PUMPSSDR AALA20140707014Cover · missingEXIT LIGHT COVER AT RT AFT GALLEY DOOR MISSING. REPLACED LIGHT ASSEMBLY FOR EXIT LIGHT COVER AT RT AFT GALLEY DOOR. OPERATIONS CHECKED NORMAL.SDR AALA20131030017Seat Track · crackedSPLICE PLATE & SEAT TRACK CRACKED AT STATION 727B & RBL 45.50. REPAIRED CRACKED SPLICE PLATE & SEAT TRACK IAW ECO J1707AA/AB & EA B737-53-032057.SDR AALA20131030016Seat Track · crackedSPLICE PLATE & SEAT TRACK CRACKED AT STATION 727 & LBL 24.75. REPAIRED CRACKED SPLICE PLATE & SEAT TRACK IAW CO J1707AA/AB & EA B737-53-032057.SDR AALA20131030015Seat Track · crackedSPLICE PLATE & SEAT TRACK CRACKED AT STATION 727B & LBL 45.50. REPAIRED CRACKED SPLICE PLATE & SEAT TRACKS IAW ECO J1707AA/AB & EA B737-53-032057.SDR AALA20131016008Seat Track · crackedSPLICE PLATE & SEAT TRACK CRACKED AT STATION 727B RBL 24.75. REPAIRED CRACKED SPLICE PLATE & SEAT TRACK IAW ECO J1707AA/AB & EA B737-53-032057.SDR AALA20130929005Fuse · blownSEAT ESCAPE PATH LIGHTS FROM ROWS 16 TO 21 RT INOPERATIVE. FOUND FUSE BLOWN FOR OUTPUT NR 12 ON EMERGENCY LIGHT BATTERY PACK M1671 & PINCHED WIRE UNDER SEAT 19R. REPLACED BLOWN FUSE & RELIEVED PINCHED WIRE UNDER SEAT 19R. OPERATIONS CHECKED NORMAL.SDR AALA20131007008Light · inoperativeEMERGENCY LIGHT ON STOW BIN AT ROW 11L INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT ON STOW BIN AT ROW 11L. OPERATIONS CHECKED NORMAL.SDR AALA20130929006Light · defectiveESCAPE PATH LIGHT ON SEAT 10R IS DIM. REPLACED LAMP FOR ESCAPE PATH LIGHT AT SEAT 10R. OPERATIONS CHECKED NORMAL.SDR AALA20130929004Light · inoperativeEMERGENCY LIGHT ON STOW BIN AT ROW 9L INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT ON STOW BIN AT ROW 9L. OPERATIONS CHECKED NORMALSDR AALA20130813007Engine · failedMIA CREW REPORTED RT ENGINE HIGH VIBRATION. EMERGENCY DECLARED FLIGHT RETURNED MIA LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED RT ENGINE AT MIA ON 08/16/2013. SYSTEM GROUND CHECKED NORMAL OPERATION OPEN.SDR AALA20120918001Slide · unsecureCREW REPORTED THAT WHILE OPENING THE LEFT NUMBER 1 DOOR THE SLIDE FELL FROM HOUSING AND DID NOT DEPLOY. REPLACED LEFT NUMBER 1 DOOR SLIDE.SDR AALA20110829MIA01Pin · looseFOUND PIN AT CONNECTOR FOR EMERGENCY SIGN AT RIGHT NUMBER 1 DOOR NOT LOCKED INTO CONNECTOR. SECURED AND LOCKED PIN IN PLACE. OPS CHECKS NORMAL.SDR AALA20110222TUL05Bulkhead · canningTHE BS 1016 REAR PRESSURE BULKHEAD HAS TWO OIL CAN DAMAGES BETWEEN STRINGERS 11 AND 15 RIGHT. INSTALLED REPAIR DOUBLER PER EA-B737-53-015431 TO AFT PRESSURE BULKHEAD.SDR AALA20110218TUL07Intercostal · corrodedTHE INTERCOSTAL AT STATIONS 927 TO 947 AND LEFT BUTTLINE 51 IS CORRODED. REMOVED AND REPLACED THE INTERCOSTAL PER SRM 51-10-02.SDR AALA20110217TUL18Support Beam · corrodedRIGHT WING LOWER TRAILING EDGE PANELS SUPPORT BEAM CORRODED AROUND NUT PLATE HOLES FROM NUMBER 8 FLAP TRACK TO NUMBER 7 FLAP TRACK. REMOVED AND REPLACED THE SUPPORT BEAM PER SRM 51-10-02.SDR AALA20110216TUL09Skin · damagedAFT CARGO DOOR HAS SEVERAL DEEP SCRATCHES. REMOVED AND INSTALLED NEW SKIN PER ESO 60651.SDR AALA20110212TUL04Angle · corrodedLEFT CREASE ANGLE AT STATIONS 900 TO 1006 IS CORRODED. REMOVED AND REPLACED THE CREASE ANGLE PER SRM 51-1-02 PARAGRAPH 8.SDR AALA20110211TUL04Stringer Clip · crackedSTRINGER CLIP CRACKED ON FORWARD SIDE OF STATION 500G FRAME AT STRINGER 26R. REPLACED STRINGER CLIP CRACKED ON FORWARD SIDE OF STATION 500G FRAME AT STRINGER 26R PER AARD 51-00-05-1.
Back to N923AN