N955AN
Service difficulty reports · 202
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 = 'N955AN' 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 = 'N955AN' 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 AALA2018111205008Floorbeam · crackedFLOORBEAM LOWER ANGLE WAS FOUND CRACKED AT BS 663 AND LBL 45.5. REPAIRED THE FLOORBEAM LOWER ANGLE IAW EA 286846.SDR AALA201811154003Angle · corrodedCORROSION ON MAIN CABIN RIGHT CREASE ANGLE BETWEEN BS 947 AND BS 987. REPLACED CREASE ANGLE IAW RD 51-00-05, AND SRM 51-40-02.SDR AALA201811154002Floorbeam · corrodedCORROSION ON MAIN CABIN FLOORBEAM, BS 986 BETWEEN LBL 51 AND RBL 51. REPAIRED THE FLOORBEAM IAW SRM 53-70-51-2R , SRM 51-40-02, AND RD 51-00-05-1.SDR AALA201811154001Web · corrodedCORROSION ON THE AFT CARGO BAY WEB AT BS 727 AND BL 0. REPLACED THE WEB IAW SRM 51-10-02, AND RD 51-00-05-1.SDR AALA201811153005Support Angle · corrodedCORROSION ON THE FORWARD CARGO BAY AFT BULKHEAD LOWER ANGLE AT BS 500I BETWEEN STRINGERS 25L AND STR 25R. REPLACED THE SUPPORT ANGLE.SDR AALA201811132004Web · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION FOUND ON THE AFT CARGO DOOR CUT OUT THRESHOLD WEB BETWEEN BS 787 AND 847, RBL 28. REPLACED THE THRESHOLD WEB.SDR AALA201811132003Angle · corrodedLEFT CABIN CREASE ANGLE HAD CORROSION FROM BS 986 - 947. REPLACED THE CREASE ANGLE IAW RD 51-00-05-1, AND DWG 147A8540.SDR AALA201811121002Transition Panel · corrodedCORROSION FOUND ON THE FORWARD CARGO BAY LEFT TRANSITION PANEL BETWEEN BS 420 AND 500I. REPLACED THE TRANSITION PANEL IAW SRM 53-00-53-2R, AND SRM 51-10-2 PAR.9.SDR AALA2018112009002Transition Panel · corrodedCORROSION FOUND ON THE AFT CARGO BAY LEFT TRANSITION PANEL BETWEEN BS 727 AND 847. REPLACED THE TRANSITION PANEL IAW RD 51-00-5-1, AND SRM 53-00-53-2R-5.SDR AALA201811508005Floor Support · crackedCABIN FLOOR SUPPORT WAS CRACKED AT BS 291, LBL 34. REPLACED THE FLOOR SUPPORT.SDR AALA20181108003Intercostal · crackedAIRCRAFT WAS IN BASE MAINTENANCE. CABIN INTERCOSTAL IS CRACKED AT STA 348.2-360. REPLACED INTERCOSTAL PER 51-00-05-1 AND DRAWING 141A5400.SDR AALA2018110128004Floor Support · crackedCABIN FLOOR SUPPORT WAS CRACKED AT BS 313, LBL 34. REPLACED THE FLOOR SUPPORT.SDR AALA201811087006Angle · corrodedCORROSION FOUND ON THE RIGHT ANGLE BETWEEN BS 300 AND 330. REPLACED THE ANGLE IAW RD 51-00-05-1.SDR AALA201811087005Transition Panel · corrodedCORROSION FOUND ON THE FORWARD CARGO BAY RIGHT TRANSITION PANEL BETWEEN BS 492 AND 500A, RBL 25. REPLACED THE TRANSITION PANEL IAW RD 51-00-05-1, AND EA 286697.SDR AALA201811076015Transition Panel · corrodedCORROSION FOUND ON THE AFT CARGO BAY RIGHT TRANSITION PANEL BETWEEN BS 727 AND 767, RBL 26. REPLACED THE TRANSITION PANEL IAW SRM 51-40-02, RD 51-00-05-01, AND EA 286656.SDR AALA201811076014Transition Panel · corrodedCORROSION FOUND ON THE FORWARD CARGO BAY RIGHT TRANSITION PANEL BETWEEN BS 500A AND 500I, RBL 25. REPLACED THE TRANSITION PANEL IAW SRM 51-40-02 AND 51-00-05-01.SDR AALA201811052008Transition Panel · corrodedCORROSION FOUND ON THE AFT CARGO BAY, RT TRANSITION PANEL BETWEEN BS 767 AND 787, RBL 25. REPLACED THE TRANSITION PANEL.SDR AALA2018111501006Transition Panel · corrodedRIGHT FORWARD CARGO TRANSITION PANEL HAD CORROSION BETWEEN BS 420 - 440, STRINGER 26. REPLACED THE TRANSITION PANEL.SDR AALA20181105001Door Frame · crackedAIRCRAFT IN BASE MAINTENANCE: R1 DOOR CUT OUT STUB FRAME CRACKED AT BS 294 AND S17R. REPAIRED STUB FRAME PER SRM 51-70-11.SDR AALA201811219003Web · corrodedCORROSION WAS FOUND ON THE HALF MOON WEB, BS 1026, LBL 3 TO LBL 18. REPLACED THE WEB IAW DWG 147A5700, AND RD 51-00-05-01.SDR AALA2018112017007Angle · corrodedCORROSION FOUND ON THE LEFT ZEE ANGLE BS 992, LBL33 - 48. REPLACED THE ANGLE.SDR AALA2018112017003Angle · corrodedCORROSION FOUND ON THE LEFT ZEE ANGLE IN THE CABIN BS 922 - 1015, LBL 32. REPLACED THE ANGLE.SDR AALA201811197002Floor Support · corrodedCORROSION FOUND ON THE RIGHT FLOOR SUPPORT BS 951 - 967, RBL 51. REPLACED THE FLOOR SUPPORT IAW RD 51-00-05-1.SDR AALA201811197004Floor Support · corrodedCORROSION FOUND ON THE LEFT CABIN FLOOR SUPPORT BS 951 - 967. REPLACED THE FLOOR SUPPORT IAW DRAWING 147A5650, AND RD 51-00-05.SDR AALA201811132002Floorbeam · corrodedCORROSION FOUND ON THE CABIN FLOORBEAM AT BS 947.5 BETWEEN LBL 16 AND RBL 6. REPAIRED THE FLOORBEAM IAW SRM 53-70-51-2R, REPAIR 5, AND EA 286927.SDR AALA2018111508002Angle · corrodedLEFT CREASE ANGLE STRAP WAS CORRODED BETWEEN BS 310 -355. REPLACED CREASE ANGLE IAW DWG 141A8112, AND RD 51-00-05-1.SDR AALA201805018002Switch · inoperativeALL LAVATORIES INOPERATIVE AT CRUISE ALTITUDE. REPLACED THE VACUUM BLOWER BAROMETRIC SWITCH IAW AMM 38-32-12. AIRCRAFT WAS GROUNDED.SDR AALA201802269078Flashlight · inoperativeCABIN EMERGENCY FLASHLIGHT AND HOLDER AND FORWARD FLIGHT ATTENDANT JUMPSEAT FLASHLIGHT IS INOPERATIVE. REPLACED BOTH EMERGENCY FLASHLIGHT ASSEMBLY AT FORWARD FLIGHT ATTENDANT SEAT PER AMM 25-64-00. OPERATIONS CHECK OK.SDR AALA20180112012Battery Pack · failedAIRCRAFT WAS NOT GROUNDED. BATTERY PACK M1674 FAILED CAPACITANCE CHECK CARD 2908. REPLACED M1674 PER MM 33-51-06.SDR AALA20180112011Battery Pack · failedAIRCRAFT WAS NOT GROUNDED. BATTERY PACK M1670 FAILS CAPACITANCE CHECK CARD 2908. REPLACED M1670 PER MM 33-51-06.SDR AALA201706249013Cover · brokenTHE AIRCRAFT WAS NOT GROUNDED. THE EMERGENCY EXIT SIGN COVER AT THE FWD ENTRY HAS DOOR HAS FALLEN DOWN AND APPEARS TO BE BROKEN. REPLACED EMERGENCY EXIT SIGN COVER WITH NEW AT FWD ENTRY DOOR . OPS CHECK NORMAL.SDR AALA201703229034Lens · unsecureLENS FELL OFF EXCITED LIGHT AT RIGHT AFTER ENTRY DOOR. INSTALLED EXIT LENS AT RIGHT AFTER ENTRY DOOR IAW GPM. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201703169004Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED. FLIGHT ATTENDANT EMERGENCY FLASHLIGHT AFT GALLEY LEFT SEAT FAILED TEST. REMOVED AND REPLACED FLASHLIGHT IAW AMM 25-64-00. OPERATIONAL CHECK GOOD.SDR AALA20170220041Lens · crackedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT THE FORWARD ENTRY DOOR HAS A CRACKED LENS COVER. REPLACED EXIT LIGHT ASSEMBLY. OPERATIONAL CHECK GOOD.SDR AALA20170217017Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT L1 DOOR HAS A MISSING LENS COVER. ITEM DEFERRED. REPLACED EXIT LIGHT ASSEMBLY IAW AMM 33-51-02. OPERATIONAL CHECK GOOD.SDR AALA20170123025Line · disconnectedAIRCRAFT WAS GROUNDED. EMERGENCY DECLARED. DURING CLIMB THE RIGHT PACK TEMPERATURE INCREASED TO 120 DEGREES. RETURNED TO MIA. MAINTENANCE FOUND THE STANDBY TEMPERATURE CONTROL VALVE LINE DISCONNECTED. RECONNECTED LINE IAW AMM 21-51-11. LEAK AND OPERATIONAL CHESDR AALA20170113006Rib · damagedAIRCRAFT IN BASE MAINTENANCE. TRAILING EDGE PANEL RIB ASSEMBLY HAS AN ELONGATED HOLE IN THE TURNBUCKLE ATTACH LUG OF INBOARD NR 5 SPOILER. REPAIRED IAW SRM 57-51-02-2R-2 AND EA 266672.SDR AALA20161221017Smoke Detector · false indicationSMOKE DETECTOR IN FORWARD LAVATORY SOUNDED ALARM. NO SMOKE OBSERVED. ACCOMPLISHED SMOKE DETECTION TEST IAW AMM 26-14-00, NO FAULTS NOTED. OPERATIONAL CHECKED GOOD.SDR AALA20161209013Battery Pack · inoperativeEMERGENCY EXIT LIGHT AT L1 DOOR IS INOPERATIVE. REMOVED AND REPLACED BATTERY PACK. OPERATIONAL CHECKED GOOD.SDR AALA20161122021Light · looseOVERHEAD EMERGENCY EXIT LIGHT AT ROW 22 HAS A LENS COVER THAT WILL NOT ATTACH DUE TO A LOOSE LIGHT ASSEMBLY. SECURED LIGHT BASE AND REINSTALLED LENS COVER IAW AMM 33-51-03. OPERATIONAL CHECK GOOD.SDR AALA20161120010Power Supply · faultyAIRCRAFT WAS GROUNDED. FORWARD LEFT OVERWING EMERGENCY LIGHTS FAIL CARD 2908 TEST FOR TIME LIMIT. REMOVED AND REPLACED EMERGENCY POWER SUPPLY M1694 IAW AMM 33-51-06. OPERATIONAL CHECK NORMAL.SDR AALA20161120009Power Supply · faultyAIRCRAFT WAS GROUNDED. FORWARD RIGHT INTERIOR OVERWING EMERGENCY LIGHTS FAIL CARD 2908 TEST FOR TIME LIMIT. REMOVED AND REPLACED EMERGENCY POWER SUPPLY M1695 IAW AMM 33-51-06. OPERATIONAL CHECK NORMAL.SDR AALA20161120008Sign · brokenAIRCRAFT WAS NOT GROUNDED. R2 DOOR AREA GALLEY EMERGENCY EXIT IDENTIFIER L1191 IS BROKEN . REMOVED AND REPLACED EXIT IDENTIFIER IAW WDM 33-51-22. OPERATIONAL CHECK NORMAL IAW AMM 33-51-00.SDR AALA20161120006Power Supply · faultyAIRCRAFT WAS GROUNDED. ROW 7 TO ROW 12 EMERGENCY LIGHTS FAIL CARD 2908 TEST FOR TIME LIMIT. REMOVED AND REPLACED EMERGENCY POWER SUPPLY M1676 IAW AMM 33-51-06. OPERATIONAL CHECK NORMAL.SDR AALA20161120005Power Supply · faultyAIRCRAFT WAS GROUNDED. AFT LEFT GALLEY EMERGENCY LIGHTS FAIL CARD 2908 TEST FOR TIME LIMIT. REMOVED AND REPLACED EMERGENCY POWER SUPPLY M1673 IAW AMM 33-51-06. OPERATIONAL CHECK NORMAL.SDR AALA20150413003Engine · bird ingestionDURING CLIMB LT ENGINE INGESTED BIRD. UPON INSPECTION OF THE LT ENG INLET, FOUND BIRD STRIKE. SMALL BIRD APPARENTLY PASSED THRU CORE. EMERGENCY DECLARED, DIVERTED, AND LANDING UNEVENTFUL. CLEANED BIRD RESIDUE FROM LT ENGINE FAN BLADES & STATOR VANES. NO DASDR AALA20141120008Skin · corrodedFUSELAGE SKIN CORROSION STATION 540 STRINGER 22L AT DRAG BRACE OTBD EDGE. REMOVED CORROSION IAW SRM 51-10-02-0G.SDR AALA20141117017Skin · corrodedFUSELAGE SKIN CORROSION BELOW LAVATORY VENT AT STATION 917 & STRINGER 22 LT. REPAIRED IAW EA B737-53-026873 REV A DATED 11/17/2014.SDR AALA20140825009Light · inoperativeRIGHT EXTERIOR OVERWING AFT EMER EXIT LIGHT INOPERATIVE. REPLACED LAMP FOR RT EXTERIOR OVERWING AFT EMER EXIT LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20140810004Lens · brokenEMERGENCY EGRESS LIGHT LENS ASSEMBLY IN FWD AISLE AREA ADJACENT TO FWD GALLEY BROKEN. R & R FWD AISLE GALLEY EMER EGRESS LIGHT ASSEMBLY. OPERATIONS CHECKED NORMAL.
Back to N955AN