N34222
Service difficulty reports · 118
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 = 'N34222' 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 = 'N34222' 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 CALA2021080601279Fitting · crackedB737-57-4-1262-SHEAR FITTING AT STATION 540 AND RBL 40.87 IS CRA CKED HANGAR NR 5866702 REMOVED AND REPLACED SHEAR FITTING AT STATION 540 AND RBL 40.87 IAW B737-800 SRM 51-40-02 AND BAC DWG 111A2000 REV ORIGINAL SEE NSA 00094 AND HANGER N/R 5866702 FOR WORK ACSDR CALA2021080601278Fitting · crackedB737-57-4-1262-SHEAR FITTING AT STATION 540 AND RBL 32.40 IS CRA CKED HANGAR NR 5866703 REMOVED AND REPLACED SHEAR FITTING AT STATION 540 AND RBL 32.40 NSA EMX N/R 00095 AND HANGAR N/R 5866703 FOR WORK ACCOMPLISHED C IR C/W. SSFR REPORT, FORM 46-0024, ENTERED SDR CALA2021080601275Fitting · crackedB737-57-4-1262-SHEAR FITTING AT STATION 540 AND RBL 15.04 IS CRA CKED HANGAR NR 5866704 REMOVED AND REPLACED SHEAR FITTING AT STATION 540 AND RBL 15.04 NSA EMX N/R00096 AND HANGER N/R 5866704 FOR WORK ACCOMPLISHED CI R C/W. SSFR REPORT, FORM 46-0024, ENTERED BSDR CALA2021080601274Fitting · crackedB737-57-4-1262-SHEAR FITTINGAT STATION 540 AND RBL 6.14 IS CRACK ED HANGAR NR 5866706 REMOVED AND REPLACED SHEAR FITTING AT STATION 540 AND RBL 6.14 I SA EMX N/R 00097 AND HANGER N/R 5866706 FOR WORK ACCOMPLISHED CI R C/W.SSFR REPORT. FORM 46-0024, ENTERED BY SDR CALA2021080401261Fitting · crackedB737-57-4-1262-SHEAR FITTING AT STATION 540 AND LBL 40.87 IS CRA CKED NR 5866698 REMOVED AND REPLACED SHEAR FITTING PER B737-800 SRM 51-40-02 AAN D DWG NO. 111A2000 REV ORIGINAL.SDR CALA2021080401260Fitting · crackedB737-57-4-1262 - SHEAR FITTING AT STATION 540 AND LBL 32.40 IS C RACKED NR 5866699 REMOVED AND REPLACED SHEAR FITTING PER B737-800 SRM 51-40-02 AND DWG NO. 111A2000 REV ORIGINAL. DATA WAS TRANSCRIBED FROM NSA EM X N/R 0091 AND HANGER N/R 5866699, WORK ACCOMPLISDR CALA2021080401258Fitting · crackedB737-57-4-1262-SHEAR FITTING AT STATION 540 AND LBL 6.14 IS CRAC KED HANGAR NR 5866701 REMOVED AND REPLACED SHEAR FITTING PER B737-800 SRM 51-40-02 AND DWG NO. 111A2000 REV ORIGINAL. DATA WAS TRANSCRIBED FROM NSA EM X N/R 00093, HANGER N/R 5866701, WORK ACCOMPSDR CALA2021080401257Fitting · crackedB737-57-4-1262-SHEAR FITTING AT STATION 540 AND LBL 15.04 IS CRACKED HANGAR NR 5866700 REMOVED AND REPLACED SHEER FITTING PER B737-800 SRM 51-40-02 AND DWG NO. 111A2000 REV ORIGINAL.SDR CALA2021073001223Fitting · crackedB737-57-4-1262 - SHEAR FITTING AT STATION 540 AND LBL 32.40 IS C RACKED NR 5866699SDR CALA2021073001222Fitting · crackedB737-57-4-1262-SHEAR FITTINGAT STATION 540 AND RBL 6.14 IS CRACK ED HANGAR NR 5866706SDR CALA2021073001221Fitting · crackedB737-57-4-1262-SHEAR FITTING AT STATION 540 AND RBL 32.40 IS CRA CKED HANGAR NR 5866703SDR CALA2021073001220Fitting · crackedB737-57-4-1262-SHEAR FITTING AT STATION 540 AND RBL 40.87 IS CRA CKED HANGAR NR 5866702SDR CALA2021073001219Fitting · crackedB737-57-4-1262-SHEAR FITTING AT STATION 540 AND LBL 6.14 IS CRAC KED HANGAR NR 5866701SDR CALA2021073001218Fitting · crackedB737-57-4-1262-SHEAR FITTING AT STATION 540 AND LBL 15.04 IS CRA CKED HANGAR NR 5866700SDR CALA2021073001217Fitting · crackedB737-57-4-1262-SHEAR FITTING AT STATION 540 AND RBL 15.04 IS CRA CKED HANGAR NR 5866704SDR CALA2021073001216Fitting · crackedB737-57-4-1262-SHEAR FITTING AT STATION 540 AND LBL 40.87 IS CRA CKED NR 5866698SDR CALA2019042600642Skin · crackedL-1 DOOR INNER SKIN HAS A CRACK APPROX 0.750 AND WORN AREAS AT AFT END EDGE BY NO.7 DOOR STOP COUNT FROM UPPER SECTION. ACCOMPLISHED PERMANENT REPAIR AT L1 DOOR INNER SKIN AND AFT FRAME NO.7 DOOR STOP PER ECRA 5211-01633.SDR CALA2019042600645Skin · crackedACCOMPLISH INTERIM REPAIR AT FUSELAGE SKIN BETWEEN STA 375 AND S TA 420 AND STR 19R & STR 21R PER UNITED EC/RA 5331-02363. ON OR BEFORE THE AIRCRAFT REACHES 50,000 TOTAL AIRCRAFT FLIGHT CYCLES, PERFORM AN INSPECTION PER PART 2 OF EC/RA 5331-02363. PLANNING TO SDR CALA2019042600644Skin · crackedACCOMPLISH INTERIM REPAIR AT FUSELAGE SKIN BETWEEN STA 177 & STA 196 AND STR 24L PER UNITED EC/RA 5331-02361. ON OR BEFORE THE A IRCRAFT REACHES 50,000 TOTAL AIRCRAFT FLIGHT CYCLES, PERFORM AN INSPECTION PER PART 2 OF EC/RA 5331-02361. PLANNING TO CONTACT E NGSDR CALA2019042600643Skin · damagedACCOMPLISHED INTERIM REPAIR AT FUSELAGE SKIN BETWEEN STA 360 & S TA 380 AND BETWEEN STR 16L & 19L PER UNITED EC/RA 5331-02362. ON OR BEFORE THE AIRCRAFT REACHES 50,000 TOTAL AIRCRAFT FLIGHT CYC LES, PERFORM AN INSPECTION PER PART 2 OF EC/RA 5331-02362. PLANN ISDR CALA2019042200621Fitting · corrodedPITTING CORROSION ON BEARING AT L-1 LOWER HINGE FUSELAGE STRUCTURE REMOVED AND REPLACED L-1 DOOR LOWER HINGE BOX P/N 141A8180Y29 PER B737-800 SRM 51-40-02.SDR CALA2019041200563Skin · corrodedBULGING AROUND RIVETS ON FUSELAGE SKIN JUST AFT OF STA 360 AT STR 23R. EVALUATED BULGED AREA AND FOUND EXFOLIATED CORROSION UNDER STRINGER 23R BETWEEN BS 360 AND 386 IAW SRM 53-00-03, REPAIR 1, FIG 204, 205.SDR CALA2019040500525Door Sill · corrodedAFT WET AREA L2 DOOR SILL INNER CHORD HAS SEVERAL SPOTS OF CORROS ION BETWEEN STA 992.8 AND STA 951. (REF NR 9892260) REMOVED AND REPLACED L2 DOOR LOWER SILL INNER CHORD IAW B737-800 SRM 51-40-02 ADD EMP:V916685SDR CALA2019040500521Structure · corrodedAFT WET AREA R2 DOOR SILL INNER CHORD HAS SPOTS OF CORROSION BETWEEN STA 950 AND STA 986. REMOVED AND REPLACED INNER CHORD AT AFT WET AREA STA 897 AND STA 1006 PER REF B737 SRM 51-40-02.SDR CALA2019040200518Skin · dentedDENT AT FUSELAGE SKIN APPROX STA 1022 BETWEEN STR 13L AND 14L 28IN AFT OF L2 DOOR KNEE HIGH ABOVE FLOR WAS FOUND TO BE OUT OF LIMITS DUE TO PROXIMITY TO SKIN SPLICE FASTNER ROW PER B737 SRM 53-00-01 AD1 STEP 4C TABLE 102 NOTE 1. ACCOMPLISHED PERMANENT REPAIR SDR CALA2019040100501Skin · dentedDENT AT FUSELAGE SKIN APPROX STA 1022 BETWEEN STR 13L AND 14L 28IN AFT OF L2 DOOR KNEE HIGH ABOVE FLOR WAS FOUND TO BE OUT OF LIMITS DUE TO PROXIMITY TO SKIN SPLICE FASTNER ROW PER B737 SRM 53-00-01 AD1 STEP 4C TABLE 102 NOTE 1. ACCOMPLISHED PERMANENT REPAIR ASDR CALA2019032200455Intercostal · crackedFWD WET AREA FLOOR SUPPORT ANGLE BETWEEN BS204 AND BS277 RBL 3 HAS A CRACK AT FASTNER HOLE REF N/R 9892269 REMOVED AND REPLACED FLOOR SUPPORT ANGLE BETWEEN BS294 TO BS277 RBL 3 AT FWD WET AREA MAIN CABIN PER REF SRM 51-40-02.SDR CALA2017120804330Oven · smokeOVEN SMOKING OR SPARKING 205 SMOKE FROM OVEN WHEN ACTIVATED. FA REPORT INSIDE CLEAN REMOVED AND REPLACED OVEN AS REQUIRED C/B RESET POS 205 OK TO CONTSDR CALA2017111003975Bulkhead · crackedPRESSURE BULKHEAD WEB HAS A CRACK AT LBL 44 AND WL 200. REPAIRED IAW ECRA 5710-02490, REV D.SDR CALA2017021700383Light · faultyEMERGENCY EXIT SIGN DOES NOT TURN OFF. REPLACED THE EXIT LIGHT, OPS CHECKED GOOD.SDR CALA2017021300349Intercostal · corrodedAT FS 916 LT JUST FWD OF LAV D LAV MOUNT PAD THERE IS AN 1/8 INCH SPOT OF SURFACE CORROSION ON TOP OF FLOORBEAM EVALUATED INTERCOSTAL AT STA 916 LT. FOUND OUT OF LIMITS PER SRM 53-00-04. REMOVED CORRODED AND INSTALLED NEW INTERCOSTAL AT STA 916 LT IAW SRM 51-4SDR CALA2017021000309Battery Pack · faultyEMERGENCY LIGHT BATTERY PACK AT RT AFT EXIT DOOR NOT HOLDING CHARGE. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK AT RIGHT HAND AFT EXIT DOOR IAW AMM 33-51-06-960-805. OPS CHECKS GOOD IAW AMM 33-51-00-710-801.SDR CALA2017010200009Sign · malfunctionedEMERGENCY EXIT SIGN DOES NOT TURN OFF. EMERGENCY EXIT SIGN BROKEN AND FALLING OFF OPS CHECKS GOOD.SDR CALA2016090600626Shaft · shearedNR 2 ENG HYD PUMP LOW PRESSURE LIGHT ILLUMINATED. PUMP TURNED OFF IAW CKLST. SYS B QTY WENT TO ZERO. HYD PUMP SHAFT FOUND SHEARED, REPLACED THE HYD PUMP SHAFT, ASSOCIATED FILTERS, SYSTEM FLUSHED, RUNS AND LEAK CHECKED GOODSDR CALA2016081800549Engine · oil consumptionICAS BRACKETED ENGINE INST OIL PRESSURE DROPPED QUICKLY TO 10% QTY. PULLED NR 2 ENG TO IDLE AND OIL STABILIZED. PERVORMED A FLAP 40 MAX BRAKE LANDING. TOUCHDOWN SOFT AIRCRAFT OVER WEIGHT LANDING. ACFT BLOCKED IN WITH 63% OIL QTY. PER TOMC NR 2 ENGINE CONSUMPTISDR CALA2016020800093Circuit Breaker · trippedCOULD NOT LOWER FLAPS NORMALLY OR WITH ALT FLAPS. FOUND ALT TE FLAP & TE POS SENSOR CB WERE OUT. THESE BREAKERS ARE LEVEL WITH FIRST OFFICERS HEADREST. AFTER CB RESET RAN FLAPS SEVERAL TIMES SUCCESSFULLY. ACCOMPLISHED FSEU BITE WITH NO FAULTS IAW FIM TASK SDR CALA2015063000537Seat Track · crackedSEAT TRACK CRACKED AT LBL 45.5, BS 727B, OTBD FLANGE, AFT HOLE, AD RELATED AD NR 2013-23-04 AMDT 39-17659. CUT OUT CRACK IAW UAL AVO 222-NSA-500 REV A & ECRA 5320-02-02542 REV ORIGINAL. FABRICATED REPAIR PARTS IAW ECRA 5320-02542 REV ORIGINAL. INSTALLED PARSDR CALA2015062900534Wire · severedSEAT ROW 28ABC EEPL RED WIRE IS SEVERED. TERMINATED CONNECTOR FOR EEPL AT SEAT ROW ABC IAW WDM 33-51-13 & BSWPM 20-42-01. OPERATIONS CHECKED GOOD.SDR CALA2015062200524Light · inoperativeRIGHT FWD OVERWING EXIT FWD WINDOW EMER LIGHT INOPERATIVE ON INBD CHECK. R & R FWD OVERWING RT EXIT FWD WINDOW EMER LIGHT IAW AMM 33-51-01, LOCATION STATION 590, WL 270, RBL 60. LIGHT MANUFACTURER PN IS GE1317. OPERATIONS CHECKED GOOD.SDR CALA2014111401449Charger · inoperativeTWO EACH EMER LIGHTS DID NOT TEST. EXTERIOR RT ESCAPE GND LT & AFT RT OVERWING ESCAPE LIGHT. REPLACED M1670 EMER EXIT BATTERY PACK & CHARGER. OPERATIONS CHECKED GOOD IAW AMM 33-51-06-960-806 & 33-51-06-960-805 ACFT RT.SDR CALA2014101301339Latch · out of positionO2 MASK DID NOT DROP DURING TEST AT FLIGHT ATTENDANT STATION DOOR 2L. FOUND DOOR LATCH LEVER INCORRECTLY CLOCKED WITH LATCH ACTUATOR PLUNGER. RESET & GND TEST IAW AMM 35-22-00. OPERATIONS CHECKED NORMAL, RESTORED TO SERVICE.SDR CALA2014092201264Fire Detector · failedENGINE OVERHEAT LIGHT NR 2 CAME ON AFTER TAKEOFF. STAYED ON TILL ENG REDUCED TO IDLE THEN STAYED OFF, LANDED. IAW LP 7864231 FOR CORRECTIVE ACTION. PERFORMED HIGH POWER RUN ON NR 2 ENG FOR FIVE MINUTES IAW MM 71-00-00, NO DEFECTS NOTED AT THE TIME. ACFT OKSDR CALA2014061800758Control Module · faultyDURING CLIMB OUT GEAR HANDLE MOVED TO OFF RESULT WAS GEAR EXTENSION. IAW QRH HANDLE MOVES UP GEAR RETRACTED NORMALLY. TROUBLE SHOT SYS FIM 32-30-00-810-809 FOUND LANDING GEAR CONTROL LEVER MODULE AT FAULT. R & R MODULE OPERATIONS ADJUSTMENT IAW MM 32-31-11-SDR CALA2014031800355Unknown · malfunctionedDURING APPROACH FLAPS LOCKED OUT AT 25 & WOULD NOT EXTEND TO 30. ALL APPLICABLE CHECKLISTS COMPLETED, LANDING WITH INCIDENT IAW FIM TASK 27-51-00-810-801. PERFORMED FSEU BITE NO FAULTS OR PREVIOUS FAULTS LAST 28 LEGS. INSPECTED FLAPS & COMPLIED WITH FLAP LOSDR CALA2013061700418Floorbeam · corrodedAFT WET AREA FLOORBEAM LOCATED AT BS 986.5 HAS GOUGE AND CORROSION UNDER FASTENER HOLE AT RBL 5. REMOVED CORRODED PREVIOUS UPPER CAP REPAIR AND INSTALLED NEW UPPER CAP REPAIR IAW ECRA 5310-05773.SDR CALA2013061200407Frame · crackedBS 480, RT FRAME CRACKED AT INBD RIVET WHERE AC GRILL OUTLET EXTRUSION BRACKET ATTACHES IN CABIN. LOCATED BETWEEN STRINGERS 8 AND 9. C/W REPAIR AT FRAME BS 480 RT IAW EA 5310-04716, REV E.SDR CALA2013061200406Frame · crackedBS 500A, FRAME CRACKED AT INBD RIVET WHERE AC GRILL OUTLET BRACKET ATTACHES BETWEEN S-8R AND S-9R. INTERIM REPAIR INSTALLED ON FRAME IAW ECRA 5310-05770 REQUIRES INSPECTION. ACCOMPLISH INSP REQ ON OR BEFORE THE ACFT REACHING 50,000 TOTAL AIRFRAME CYCL. PLANSDR CALA2013061200404Bulkhead · crackedLEFT WHEEL WELL FWD BULKHEAD VAPOR BARRIER HAS CRACK, APPROX 10" IN LENGTH, LOCATED OTBD OF KEELBEAM. REPAIRED LT WHEEL WELL BULKHEAD AS REF SRM 57-10-10, REPAIR 2, SEE ENTRIES BELOW FOR PREVIOUS WORK PERFORMED,SDR CALA2013060300385Frame · crackedBS 727D, FRAME CRACKED AT INBD RIVET WHERE AC GRILL OUTLET ATTACHES IN CABIN. LOCATED BETWEEN STRINGERS 8 AND 9L. REPAIR FRAME IAW EA 5310-04716, REV E.SDR CALA2013060300382Frame · crackedBS 500A FRAME CRACKED AT INBD RIVET WHERE AC GRILL OUTLET EXTRUSION BRACKET ATTACHES IN CABIN. LOCATED BETWEEN STRINGERS 8 AND 9L. FABRICATED AND INSTALLED REPAIR ANGLES TO FRAME AT STA 500A LT BETWEEN STRINGERS 8 AND 9 REF EA 5310-04716, REV E.
Back to N34222