N16703
Service difficulty reports · 96
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 = 'N16703' 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 = 'N16703' 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 CALA2017081402660Skin · dentedFWD CARGO DOOR OUTER SKIN HAS A DENT LOCATED AT 20IN FROM TOP AND 11.5 INCHES FROM FWD EDGE ADJACENT TO A PREVIOUS EXTERNAL DOUBLER REPAIR ACCOMPLISHED DOUBLER REPAIR AT EXTERNAL SKIN IAW 52-00-01.SDR CALA2017081402659Panel · crackedL1 DOOR CUTOUT SKIN AT UPPER HINGE HAS A CRACK ON PANEL. REMOVED DAMAGED SKIN AT UPPER HINGE ANGLE IAW SRM 51-10-2. PREFORMED HFEC INSPECTION AROUND SKIN CUTOUT IAW NDTM PART 6 51-00-00 PER 23. CRACK CONFIRMED. FABRICATED A REPAIR IAW DWG 141A8222, AND SRSDR CALA2017021700376Indicator · faultySTANDBY ALTIMETER PROBLEM, CAPTAIN`S AND FO`S ALTIMETERS 5350. STANDBY ALTIMETER 5540. REPLACED THE STANDBY ALTIMETER AND AIRSPEED INDICATORS IAW AMM 34-13-01SDR CALA2016101900787Light · brokenL2 DOOR EMERGENCY "EXIT LIGHT" BROKEN. REPLACED LIGHT BASE, CHKED OK.SDR CALA2016032900195Structure · damagedOUTBOARD CHORD IS DAMAGED AT HIGH PRESS PNEUMATIC ACCESS DOOR. OTBD LATCH POINT REPAIRED IAW ECRA 5351-01122 SEE 008 FOR WORK DESCRIPTION.SDR CALA2016022200123Windshield · crackedPASSING 33,000 FT, WINDSHIELD L1 OUTER PANE CRACKED DUE TO OVERHEAT, OUTER PANE ONLY. REPLACED L1 WINDSHIELD IAW AMM 56-11-11 & LT WINDOW HEAT CONTROLLER IAW AMM 30-41-11. ALL TESTED OK.SDR CALA2015092500801Switch · failedLEADING EDGE FLAP TRANSIT LIGHT ILLUMINATED & STAYED LIT AT FLAPS 1. RAN QRH & SELECTED FLAPS 5, LIGHT WENT OUT & LANDING WAS NORMAL. LE FLAPS NR 3 WAS THE ONE STICKING. REF LOG PAGE 8285012 FOR CORRECTIVE ACTION.SDR CALA2015092100784Light · inoperativeEMERGENCY LIGHT ON STOW BIN 2EF BULLNOSE. RELAMPED STOW BIN LIGHT ON BIN 2EF IAW AMM 33-51-00. SYS CHECKED GOOD IAW AMM 33-51-00.SDR CALA2015032300194Window · out of adjustAIR RETURN FOR LOUD SQUEAL IN COCKPIT, COULD NOT HEAR. PRESSURIZED FIRST OFFICERS SLIDING WINDOW. FOUND LEAK AT FWD UPPER CORNER. ADJUSTED WINDOW CLEARANCE IAW MM 56-12-11-820-801. INSPECTED SEAL & PRESSURIZED TO 5.5 PSI. NO LEAKS OR PRESSURIZATION FAULTSSDR CALA2014100801322Skin · corrodedC2 DOOR INNER SKIN, FWD LOWER CORNER HAS CORROSION AT SNAP ATTACH POINT. TRIMMED OUT CORRODED SECTION & INSTALLED REPAIR IAW ECRA 5230-01945.SDR 39NR20130804018Pressure Panel · crackedDURING INSPECTION, FOUND TWO CRACKS 1 INCH AT BS 663 VERTICAL PRESSURE WEB AT LBL 41, WL 195 AND LBL 43, WL 197. REPAIRED VERTICAL WEB IAW SRM 57-10-10, REPAIR NR 3.SDR 39NR20130814017Pressure Panel · crackedDURING INSPECTION, FOUND TWO CRACKS, 1 INCH AND .5 INCH AT BS 663 VERTICAL PRESSURE WEB AT RBL 34, WL 196 AND RBL 42, WL 197. REPAIRED VERTICAL PRESSURE WEB IAW SRM 57-10-10, REPAIR NR 3.SDR CALA2013081400564Structure · crackedCTR WING BOX REAR SPAR WEB AT BS 663 RT SIDE FOUND 1 INCH CRACK AT RBL 42 & WL-197. ALL WORK ACCOMPLISHED IAW SRM 57-10-10, REPAIR-3, PAGE-209, FIG-20 4 AND IAW PAGE 211, TABLE-B.SDR CALA2013081400563Structure · crackedCENTER WING BOX REAR SPAR WEB AT BS 663 LT SIDE FOUND 1" CRACK AT LBL-43 & WL-197. ALL WORK ACCOMPLISHED IAW SRM 57-10-10, REPAIR-3, PAGE-209, FIG-20 4 AND IAW PAGE 211, TABLE-B.SDR CALA2012051400352Frame · crackedPERFORMED MFEC IAW EA 5310-04716 REV C CRACK INDICATION NOTED AT STA 380R. REPAIRED FRAME 380R IAW ECRA 5310-05509.SDR CALA2012051400351Frame · crackedPERFORMED HFEC IAW EA 5310-04716. CRACK INDICATION NOTED AT STA 380L IN RADIUS REPAIRED FRAME 380L IAW ECRA 5310-05509.SDR CALA2012051400350Frame · crackedMFEC INSPECTION SHOWS A CRACK INDICATION AT FRAME 400L REPAIRED FRAME AT STA 400L IAW ECRA 5310-05509.SDR CALA2012051400349Frame · crackedLEFT FRAME AT BS 440L CRACKED IN RADIUS REPAIRED FRAME AT STA 440L IAW ECRA 5310-05509.SDR CALA2012051400348Stringer · crackedSTR 8L AT STA 827L HAS DAMAGE ON FREE FLANGE. REPAIRED STR 8L AT STA 827L IAW ECRA 5311-01549.SDR CALA2012051400347Frame · crackedCRACK INDICATION IN RADIUS AT BS 480L. REPAIRED FRAME 480L IAW ECRA 5310-05509.SDR CALA2012051400345Frame · crackedSUPPORT TASK PERFORMED MFEC IAW EA 5310-04716, REV C. CRACK INDICATION NOTED AT STA 907, RT ACCOMPLISHED INTERIM REPAIR IAW ECRA 5310-05508. PLACED ON DIP TO ACCOMPLISH A PERM REPAIR PRIOR TO 50,000 FLT CYCLES. PLANNING TO CONTACT ENGINEERING AFTER 43,000 TSDR Z6WR20120510008Panel · debondedULTRASONIC INSPECTION IAW NDT MANUAL REVEALS THE THRUST REVERSER 315A2101-141 INNER WALL HAS AN AREA OF DISBOND 1.8 X 2.0" LOCATED 18.5" FROM AFT EOP AND 6.0" FROM UPR EOP IN THE FOOT PRINT OF THE NR 3 UPPER COMPRESSION PAD. VISUAL AREA OF DISCOLORATION C/T 3SDR CALA2012050700328Frame · crackedSUPPORT TASK STA 294.5 TO 303.9, LT ABOVE LAV FRAME CRACK. R & R FRAME AT STA 294.5 TO 303.9 LT IN REF SRM 51-40-02.SDR CALA2012050200323Frame · crackedSUPPORT TASK PERFORMED MFEC IAW EA 5310-04716, REV C. OP1 REPAIRED FRAM AT STA 867 IAW EA5310-04716, REV C, OP 1 SEE ATTACHED FORM 44.0008 FOR ALL WORK PERFORMED.SDR CALA2012050200322Frame · crackedSUPPORT TASK LT SIDE FRAME AT STA 727D CRACKED REPAIRED FRAME AT STA 727D LT IAW EA 5310-04716, REV C, OP1 SEE ATTACHED, FORM 44.0008.SDR CALA2012043000314Frame · crackedSUPPORT TASK PERFORMED MFEC IAW EA 5310-04716 REV C CRACK INDICATION NOTED AT STA 500A R. REPAIRED FRAME AT STA 500A RT SIDE REF EA 5310-04716. SEE ATTACHED FORM 44.0008 FOR WORK ACCOMPLISHED.SDR CALA2012043000312Frame · crackedSUPPORT TASK, PERFORMED MFEC IAW EA 5310-04716, REV C. CRACK INDICATION NOTED AT STA 747 RIGHT, ACCOMPLISHED PERMANENT REPAIR IAW EA 5310-04716.SDR CALA2012043000311Frame · crackedSUPPORT TASK PERFORMED MFEC IAW EA 5310-04716, REV C CRACK INDICATION NOTED AT STA 480. RT REPAIRED FRAME AT STA 480 RT IAW EA 5310-04716, REV C. SEE ATTACHED FORMS 44.0008 FOR WORK PERFORMED.SDR CALA2012043000310Frame · crackedSUPPORT TASK. PERFORMED MFEC IAW EA 5310-04716, REV C. CRACK INDICATION NOTED AT STATION 727D RT REMOVED CRACK AND REPAIR FRAME AT STA 727D RT IAW 5310-04716, REV C AND IAW SRM 51-40-02 REINSTALL BRACKET IAW SRM 51-40-02. SEE ATTACHED FOR 44.0008 FOR ALL WORSDR CALA2012043000309Frame · crackedSUPPORT TASK MFEC INSP SHOWS CRACK INDICATION AT STA 500C LT FRAME. REPAIRED FRAME AT STA 500C LT IAW EA 5310-04176, REV C. SEE ATTACHED FORM 44.0008 FOR WORK PERFORMED.SDR CALA2012043000308Frame · crackedSUPPORT TASK PERFORMED HFEC IAW EA 5310-04716, REV C, CRACK INDICATION NOTED AT STA 440R. REPAIRED FRAME AT STA 440 R IAW EA 5310-04716, REV C. SEE ATTACHED FORM 44.0008 FOR WORK PERFORMED.SDR CALA2012043000305Frame · crackedSUPPORT TASK - PERFORMED MFEC PER EA 5310-04713 REV C. CRACK INDICATION NOTED AT STATION 827R PERFORMED REPAIR PER EA 5310-04716 REV C.SDR CALA2012043000304Frame · crackedSUPPORT TASK LEFT SIDE FRAME AT STATION 867 CRACKED. PERFORMED REPAIR PER EA 5310-04716 REV C.SDR CALA2012043000303Frame · crackedSUPPORT TASK MFEC INSP SHOWS CRACK INDICATION AT STA 827 LT FRAME. REPAIRED IAW EA 5310-04716 REV C OP 1.SDR CALA2012042700302Skin · crackedSUPPORT TASK LT HORIZONTAL STAB LOWER SKIN AT STA 147.90 APPROX 24 " AFT OF L/E HAS A 1 " CRACK LT LOWER STAB SKIN REPAIRED AT STA 147.90 IAW SRM 55-10-01, REPAIR 11. REPAIR TO BE INSP AFTER 56000 FLT CYC FOLLOWED BY REPEAT INSP AT 9000 FLT CYC IAW STEP 5A TASDR CALA2011100700651Regulator · inoperativeAT CRUISE AND CLIMB DUCT PRESSURE SPLIT OF 30 PSI L/12PSI R/46 PSI ON DESCENT R/35PSI L/8PSI CABIN VSI ON PRESSURIZATION PANEL FLUCTUATED FROM 0 CLIMB TO 1000 FT PER MIN T/S REF AMM 36-10 FOUND A/C TO BE OK. RAN LEFT ENGINE AND ALL PRESSURE GOOD SEE L/P 89127SDR CALA2010080300367Spar · crackedSUPPORT TASK, RIGHT MAIN GEAR WELL, FWD WALL CRACKED APPROX 13 INCHES LONG RBL 45.64 AND 54.21. INSTALLED BRACE REPAIRS IN BAY 8, 9, 10 RT SIDE REF SRM 57-10-10 REPAIR 2 AND ECRA 5710-02180.SDR CALA2010060800255Light · inoperativeSUPPORT TASK, MAIN CABIN EPL ON SEAT 14C BULB/OUT/BURNT/INOP. RELAMPED MAIN CABIN EPL ON SEAT 14C; IAW B737 AMM 33-51-11; OPS CHECKED GOOD; IAW B737 AMM 33-51-11.SDR CALA2010060800254Light · inoperativeSUPPORT TASK, MAIN CABIN EMERGENCY EXIT SIGN ON CEILING AT 17 HAS BULB OUT. RELAMPED MAIN CABIN EMERGENCY EXIT SIGN ON CEILING AT 17; IAW B737 AMM 33-25-00; OPS CHECK GOOD; IAW B737 AMM 33-25-00.SDR CALA2010060800253Frame · misrepairedSUPPORT TASK: 4 EACH FRAME TIES (P/N N22007-001) LOCATED AT BS 727E L/R AND BS 727D LT, EXISTING FASTENERS LOCATIONS DO NOT MEET MINIMUM EDGE DISTANCE COMPLIED WITH ECRA 5310-05206 REV.SDR CALA0800212Frame · crackedFRAME CRACKED STA 400 AT S-9R. INTERIM REPAIR PER ECRA5310-04729. DIP CONTROL NUMBER 86938.SDR CALA0800211Frame · crackedFUSELAGE FRAME CRACKED AT BRACKET MOUNT BETWEEN STR 8 AND 9 LT AT STA 747. INTERIM REPAIRED PER ECRA5310-04729. DIP CONTROL NUMBER 86938.SDR CALA0800210Frame · crackedFUSELAGE FRAME CRACKED BETWEEN STR 8 AND 9 LT AT STA 787. INTERIM REPAIRED PER ECRA5310-04729. DIP CONTROL NUMBER 86938.SDR CALA0800184Stringer · crackedSTRINGER 15L IN CABIN CRACKED JUST FORWARD OF WING ILLUMINATION LIGHT HOUSING APPROX BETWEEN STA 460-480. INSTALLED REPAIR PARTS PER SRM 53-00-03.SDR CALA0500326Floorbeam · corrodedINSPECTION FOUND SEVERAL NUT CLIP HOLES ON FLOORBEAM CORRODED AT STA 986.5, LBL 43-LBL 45. REPAIRED IAW ECRA 5321-01297.SDR CALA0300373Display · inoperativeTHE CAPTAIN'S OUTBOARD PRIMARY FLIGHT DISPLAY FAILED INFLIGHT. A STRONG BURNING ODOR WAS PRESENT IN THE COCKPIT. THE CENTER DISPLAY UNIT AND INBOARD DISPLAY UNIT FLICKERED ON APPROACH. THE AIRCRAFT LANDED WITHOUT INCIDENT.
Back to N16703