N107US
Service difficulty reports · 220
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 = 'N107US' 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 = 'N107US' 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 AALA201705229051Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION ON DOOR SILL AT Y1262 AND FR 68. REPAIRED DOOR SILL PER SRM 53-41-14-300-001.SDR AALA201705229050Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION ON DOOR SILL AT -Y1262 AND FR 68. REPAIRED DOOR SILL PER SRM 53-41-14-300-001.SDR AALA201705229034Attach Bracket · crackedAIRCRAFT IN BASE MAINTENANCE. CRACKED LEFT HAND AFT EMERGENCY EXIT DOOR BEAM NR 1 ATTACHED BRACKET. REPLACED ATTACH BRACKET PER SRM 51-42-11.SDR AALA201705229033Bracket · crackedAIRCRAFT IN BASE MAINTENANCE. CRACKED RIGHT HAND FORWARD EMERGENCY EXIT DOOR BEAM #1 ATTACHED BRACKET. REPLACED BRACKET PER SRM 51-42-11.SDR AALA201705229032Attach Bracket · crackedAIRCRAFT IN BASE MAINTENANCE. CRACKED RIGHT HAND AFT EMERGENCY EXIT DOOR BEAM NR 1 ATTACHED BRACKET. REPLACED ATTACH BRACKET PER SRM 51-42-11.SDR AALA201705239023Attach Bracket · gougedAIRCRAFT IN BASE MAINTENANCE. L2 DOOR AFT UPPER CUTOUT FRAME DOOR HANDLE ATTACHED BRACKET HAS GOUGE. REMOVE AND REPLACED DOOR HANDLE ARM ATTACHED BRACKET.SDR AALA201704129016Angle · migratedDOOR, LEFT AFT EMERGENCY EXIT ECAM DURING CLIMBOUT. PRESSURIZATION NORMAL. ADJUSTED RETAINING ANGLE ON LEFT AFT EMERGENCY EXIT COVER. REINSTALLED ALL ECAM AND OTHER INDICATIONS NORMAL.SDR AALA201703169038Engine · power lossDURING FLIGHT, CREW REPORTED THE NUMBERS ON THE NR 1 ENGINE ROLLED BACK. PATCH WITH TECH WAS REQUESTED AND AN ENGINE STALL WARNING MESSAGE OCCURRED. TECH ADVISED DIVERSION TO MIA FOR BETTER MAINTENANCE. NO EMERGENCY WAS DECLARED AND THE FLIGHT LANDED WITHOUT ISDR AALA201703079022Seal · migratedAIRCRAFT NOT GROUNDED. DOOR LEFT AFT EMERGENCY EXIT ECAM MESSAGE ILLUMINATED WHILE CLIMBING, AIRCRAFT PRESSURIZATION NORMAL. EXIT DOOR SEAL IMPRPOPERLY SEATED. ADJUSTED DOOR SEAL & CHECKED NORMAL .OK FOR SERVICE.SDR AALA201701039001Cover · brokenTHE EMERGENCY LIGHT COVER AT BOTTOM OF SEAT 3C IS BROKEN. MAINTENANCE REPLACED THE COVER IAW AMM 33-51-18.SDR AALA201612279002Box Beam · crackedCRACK IN LEFT SIDE BOX BEAM UPPER FLANGE THIRD FASTENER HOLE AT FR 43. REPAIRED LEFT SIDE BOX BEAM PER EO 5315Y066.SDR AALA201612279001Box Beam · crackedCRACK IN RIGHT SIDE BOX BEAM UPPER FLANGE THIRD FASTENER HOLE.AT FR 43. REPAIRED SIDE BOX BEAM PER EO 5315Y066.SDR AALA201610249004Reservoir · low pressureAIRCRAFT WAS NOT GROUNDED. CAUTION LIGHT INDICATION ON CIDS PANEL DUE TO LOW PRESSURE ON LEFT EMERGENCY OVERWING ESCAPE SLIDE RESERVOIR. REPLACED ESCAPE SLIDE RESERVOIR PER AMM 25-62-46-0401.SDR AALA201609119003Seat · out of adjustAIRCRAFT WAS NOT GROUNDED: SEATBACK AT 10C RECLINES TOO FAR. BEING ON THE EMERGENCY EXIT ROW, IT SHOULDN'T RECLINE AT ALL. MAINTENANCE ADJUSTED SEAT AT 10C SO IT NO LONGER RECLINES.SDR AALA201608089009Transfer Valve · faultedFUEL LEFT CELL VALVE INOPERATIVE. MAINTENANCE ACCOMPLISHED TSM 28-15-00-810 AND REPLACED THE LEFT FORWARD SPAR TRANSFER VALVE ACTUATOR 9QP IAW AMM 28-15-51. A SATISFACTORY OPS CHECK WAS ACCOMPLISHED.SDR AALA201603209006Power Supply · failedAIRCRAFT WAS NOT GNDED. EMER POWER SUPPLY UNIT 10WL, UNIT FAILURE, DETECTED DURING WEEKLY CHECK CARD 26L00005005. REPLACED POWER SUPPLY UNIT & ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-38-0401.SDR AALA201602179002Battery · dischargedAIRCRAFT WAS NOT GNDED. AFT RT FLIGHT ATTENDANTS FLASHLIGHT INOPERATIVE. REPLACED FLASHLIGHT BATTERY & ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201512029003Slide Raft · faultyAIRCRAFT WAS NOT GNDED. EMER LIGHT TEST GIVES ESPU LT EXTERNAL FAULT. REPLACED FWD RT SLIDE RAFT IAW TASK CARD 26L00025011.SDR AALA201508039006Lens · missing26C EMERGENCY LIGHT PLATE MISSING. INSTALLED LENS FOR EMERGENCY LIGHT. AIRCRAFT OK FOR SERVICE.SDR AALA201507139004Wire Harness · brokenFLIGHT 1813 EN-ROUTE, ECAM WHEEL BRAKES HOT ON NR 3 MAIN, INBD RT MAIN. EXTENDED GEAR IAW PROCEDURE, DID NOT COOL BRAKES, INDICATION VARIES IN TEMP. R & R BSCU IAW AMM 32-42-34 BITE CHECK OK. TROUBLESHOT NR 3 BRAKE TEMP IAW ASM 32-47-01 & AWM 32-11-02. FOSDR AALA201507099005Btms · faultyFLIGHT 1960 EN-ROUTE, AFTER TAKEOFF NR 3 BRAKE TEMP JUMPED TO 450, 1.75, 2.70, 3.450 & 4. 50 TRIGGERED, BRAKES HOT ECAM IAW TSM 32-47-00-810-818-A. R & R BRAKE TEMP MONITORING UNIT 2 GW IAW AMM 32-47-18-400-001-A. OPERATIONS OK FOR SERVICE.SDR USAA2014082600002Skin · saturatedC11 CHECK WATER INGRESS & DELAMINATION ON LT ELEVATOR UPPER SKIN APPROX 85.5 INCHES FROM INBD END & 7.25 INCHES FROM TE ALSO AT 54.5 INCHES FROM INBD END & 6.5 INCHES FROM TE. REPLACED LT ELEVATOR IAW MM 27-34-41 & 27-34-00.SDR USAA2014082500023Skin · saturatedC11 CHECK WATER INGRESS & DELAMINATION ON LT ELEVATOR UPPER SKIN APPROX 28 INCHES FROM INBD END & 8 INCHES FROM TE. REPLACED LT ELEVATOR IAW MM27-34-41 & 27-34-00.SDR USAA2014082200015Skin · saturatedC11 CHECK TRAPPED WATER INDICATION ON UPPER SURFACE OF RT ELEVATOR APPROX 22 INCHES FROM TE & 87.5 INCHES FROM INBD EDGE. REPAIRED RT ELEVATOR UPPER SURFACE IAW SRM 55-21-11-201 PARAGRAPH 5E.SDR USAA2014082200010Slide Raft · defectiveC11 CHECK R2 DOOR SLIDE ASSEMBLY UNRAVELED DURING REMOVAL. REPLACED R2 DOOR SLIDE RAFT IAW AMM TASK 25-62-44 PB 401.SDR USAA2014070800006Girt Bar · dirty2R DOOR ARMING MECHANISM MAKES GRINDING NOISE WHILE TRYING TO CLOSE OR OPEN. FLIGHT ATTENDANT SAYS IT DOESN'T FEEL NORMAL. FOUND DEBRIS ON GIRT BAR AT FLOOR ATTACH BRACKETS. CLEANED DEBRIS & LUBED IAW AMM 12-22-52-640-014-A.SDR USAA2014041100010Proximity Sensor · out of adjustRETURN TO FIELD FOR GEAR FAULT ON CLIMB OUT & GEAR WOULD NOT RETRACT. CREW DECLARED AN EMERGENCY & RETURNED TO DEPARTURE. LANDED & TAXIED WITHOUT INCIDENT. FOUND PROXIMITY SENSORS 32GA & 34GA FOR RT MLG DOOR FAULTED & OUT OF ADJUSTMENT. REPLACED PROXIMITY SDR USAA2014010800010Computer · faultyELAC 2 PITCH FAULT IN FLIGHT CAUSING ACFT TO PITCH DOWN. REPLACED ELAC NR 2 IAW A320 AMM 27-93-34-000-001-A & 27-93-34-100-001-A, & ELECTRONIC MODULE IN POS NR 1 IAW LP 8448757, IAW A320 AMM 27-44-57-000-002-A.SDR USAA2013081200006Line · leakingABOUT TO LEVEL AT FL 340, LOST GREEN HYD SYS COMPLIED WITH ECAM & QRH RETURNED TO DEPARTURE. FOUND LEAKING HYDRAULIC LINE ON NR 1 ENGINE, REPLACED LEAKING PRESSURE SWITCH LINE IAW AMM 29-11-49-400-005-A.SDR USAA2012121400002Power Supply · failedGOGO MOD - EMERGENCY LIGHT TEST FAILED MESSAGE: EPSU INT LOAD AFT L REMOVED AND REPLACED EPSU (13L) PER AMM 33-51-38. PERFORMED SATISFACTORY TEST PER TASK 33-51-00-710-001-A.SDR USAA2012121400001Power Supply · failedGOGO MOD - EMERGENCY LIGHT TEST FAILED MESSAGE: EPSU INT LOAD EMER, L REMOVED AND REPLACED EPSU (11L) PER AMM 33-51-38. PERFORMED SATISFACTORY TEST PER TASK 33-51-00-710-001-A.SDR USAA2012013000016Oven · faultyUPON PICKING UP AIRCRAFT IN DTW, THERE WAS A STRONG EXHAUST TYPE SMELL THROUGHOUT ENTIRE AIRCRAFT. THIS WAS WITH NO EXTERNAL AIR AND APU WAS OFF. ODOR LESSENED DURING OPERATIONAL CHECK WITH PACKS ON BUT DID NOT GO AWAY. CREW MEMBERS REPORTED HEADACHES AND NSDR USAA2011091200012Damper · unserviceable2S CHECK - DURING OPERATIONAL TEST OF DAMPING FUNCTIONAL WAS FOUND HARD IMPACT BETWEEN FUSELAGE AND BUFFER AT DOOR 831. REPLACED DOOR DAMPER AND EMERGENCY OPERATION CYLINDER AT PASS/CREW DOOR 831 IAW A320 AMM 52-11-14-400-001.SDR USAA2011090800012Fuel Door · out of tolerance2S CHECK - RIGHT WING LOWER FUEL DOOR ASSEMBLY 640FB IS OUT OF WEIGHT LIMITS BETWEEN WS 6132 TO WS 6699 & BETWEEN RIB 11 TO RIB 12. REPLACED RIGHT WING LOWER FUEL DOOR ASSEMBLY 640FB IAW A320 AMM 57-27-11.SDR USAA2011090800011Fuel Door · out of tolerance2S CHECK - LEFT WING LOWER FUEL DOOR ASSEMBLY 540GB IS OUT OF WEIGHT LIMITS BETWEEN WS 6699 TO WS 7316 & BETWEEN RIB 12 TO RIB 13. REPLACED LEFT WING LOWER FUEL DOOR ASSEMBLY 540GB IAW A320 AMM 57-27-11.SDR USAA2011090800014Web · cracked2S CHECK - CRACK ON FLOOR STRUCTURE WEB BETWEEN FR8 TO FR11, Y765. REPLACED FLOOR STRUCTURE WEB BETWEEN FR8 TO FR11, Y765 IAW A320 SRM 51-72-11 & AIRBUS DRAWING D53113219.SDR USAA2011090800013Web · cracked2S CHECK - CRACK ON FLOOR STRUCTURE WEB BETWEEN FR8 TO FR11, -Y765. REPLACED FLOOR STRUCTURE WEB BETWEEN FR8 TO FR11, -Y765 IAW A320 SRM 51-72-11 & AIRBUS DRAWING D53113219.SDR USAA2011090900013Floor Panel · delaminated2S CHECK - DELAMINATION ON FLOOR PANEL 151GF BETWEEN FR53 TO FR56 & BETWEEN -Y765 TO Y765. REPLACED FLOOR PANEL 151GF IAW MCGILL IRM 9701 REV G & A320 SRM 53-02-00.SDR USAA2011090800024Floor Panel · delaminated2S CHECK - DELAMINATION ON FLOOR PANEL 151DF BETWEEN FR49 TO FR53 & BETWEEN Y765 TO -Y765. REPLACED FLOOR PANEL 151DF BETWEEN FR49 TO FR53 & BETWEEN Y765 TO -Y765 IAW A320 SRM 53-02-00 & MCGILL IRM 9701 REV G.SDR USAA2011090800010Fitting · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON LEFT FORWARD DOOR CUTOUT CENTER FITTING BETWEEN FR16 TO FR20 S23L. REPLACED LEFT FORWARD DOOR CUTOUT CENTER FITTING IAW A320 SRM 51-72-11 & AIRBUS DRAWING D53112109.SDR USAA2011090800022Seat Track · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON SEAT TRACK ASSEMBLY BETWEEN FR35 TO FR36, -Y765. REPLACED SEAT TRACK ASSEMBLY BETWEEN FR35 TO FR36, -Y765 IAW A320 SRM 51-72-11 & AIRBUS DRAWING D53371024.SDR USAA2011090800021Seat Track · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON SEAT TRACK ASSEMBLY BETWEEN FR35 TO FR36, Y765. REPLACED SEAT TRACK ASSEMBLY BETWEEN FR35 TO FR36, Y765 IAW A320 SRM 51-72-11 & AIRBUS DRAWING D53371024.SDR USAA2011090800017Seat Track · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON SEAT TRACK AT FR32, Y1292. REPAIRED SEAT TRACK AT FR32, Y1292 IAW A320 SRM 53-00-15 FIG 201.SDR USAA2011090800016Seat Track · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON RAIL SEAT BETWEEN FR55 + 11 INCHES TO FR64, Y1292. REPAIRED RAIL SEAT BETWEEN FR55 + 11 INCHES TO FR64, Y1292 IAW A320 SRM 51-72-11 & AIRBUS DRAWING D53472770.SDR USAA2011090800015Seat Track · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON RAIL SEAT BETWEEN FR47 TO FR55 + 11 INCHES, Y1292. REPAIRED RAIL SEAT BETWEEN FR47 TO FR55 + 11 INCHES, Y1292 IAW A320 SRM 53-41-15 FIG 202.SDR USAA2011090800009Hinge Fitting · excess play2S CHECK - PLAY EXCESSIVE AT RUDDER NR 2 HINGE. REPLACED RUDDER NR 2 HINGE FITTING ASSEMBLY AT RUDDER STA 1926/RIB 4 IAW A320 AMM 55-36-41 & SRM 51-42-11.SDR USAA2011090800008Hinge Fitting · excess play2S CHECK - PLAY EXCESSIVE AT RUDDER NR 1 HINGE. REPLACED RUDDER NR 1 HINGE FITTING ASSEMBLY AT RUDDER STA 780/RIB 2 IAW A320 AMM 55-36-41 & SRM 51-42-11.SDR USAA2011090800007Angle · cracked2S CHECK - CRACK ON EMERGENCY EXIT DOOR 843 SEGMENT ANGLE BETWEEN FR38 TO FR39 & BETWEEN BEAM 1 TO BEAM 4. REPLACED SEGMENT ANGLE AT EMERGENCY EXIT DOOR 843 IAW EO 5210Y228.SDR USAA2011090800006Angle · cracked2S CHECK - CRACK ON EMERGENCY EXIT DOOR 834 SEGMENT ANGLE BETWEEN FR40 TO FR41 & BETWEEN BEAM 1 TO BEAM 4. REPLACED SEGMENT ANGLE AT EMERGENCY EXIT DOOR 834 IAW EO 5210Y228.SDR USAA2011090800005Angle · cracked2S CHECK - CRACK ON EMERGENCY EXIT DOOR 833 SEGMENT ANGLE BETWEEN FR38 TO FR39 & BETWEEN BEAM 1 TO BEAM 4. REPLACED SEGMENT ANGLE AT EMERGENCY EXIT DOOR 833 IAW EO 5210Y228.
Back to N107US