N83873, cancelled Dec 21, 2004
Service difficulty reports · 91
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 = 'N83873' AND deregistration_id = 'N83873-2004-12-21' 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 = 'N83873' AND deregistration_id = 'N83873-2004-12-21' 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 CALA0100797Frame · crackedINSPECTION FOUND A 2" CRACK IN TAIL COMPARTMENT CANTED FRAME AT STA 1418, L2R AND A 4" CRACK IN FRAME AT L2L. THE CRACKED SECTION OF FRAME WAS REMOVED AND A NEW SECTION WAS INSTALLED IAW SRM 51-30-5 AND 53-03, FIGURE 32.SDR CALA0100768Channel · corrodedINSPECTION FOUND AFT NOSE WHEEL WELL AFT DOOR CHANNEL AT L/H O/B SIDE. THE CHANNEL WAS REMOVED AND REMOVED IAW SRM 51-30-02.SDR CALA0100766Frame · corrodedINSPECTION FOUND BELT FRAME CORRODED AT LOWER J IN AFT PIT AT STA 1271 BETWEEN LONGERONS 29R AND 29L. THE BELT FRAME WAS REPAIRED IAW SRM 53-03.SDR CALA9900357Doubler · corrodedINSPECTION FOUND DOUBLER CORRODED AT STA 1336 BETWEEN S18R AND S17R IN RT LAV. NEW FILLER WAS INSTALLED IAW SRM 51-30-0.SDR CALA9900356Beltframe · corrodedINSPECTION FOUND BELTFRAME CORRODED AT STA 1338, RT LAV, APPROXIMATELY SIX INCHES UP FROM FLOOR. A SPLICE REPAIR WAS INSTALLED IAW ECRA 5310-03837.SDR CALA9900355Handle · out of adjustTHE TAIL CONE EXTERIOR RELEASE HANDLE CATCHES ON LOWER LIP OF SKIN CUTOUT PREVENTING PULL OF HANDLE. INSPECTED HANDLE AND ADJUSTED CATCH WITHIN LIMITS AND PERFORMED ADJUSTMENT/TEST OF TAIL CONE RELEASE SYSTEM IAW MM 53-53-00.SDR CALA9900353Skin · crackedINSPECTION FOUND A .5 INCH CRACK IN FORWARD ENTRY DOOR SKIN AT LOWER FORWARD CORNER OF DOOR EDGE. A REPAIR WAS INSTALLED IAW SRM 52-05, FIGURE 32, SHEET 2 AND 3.SDR CALA9900351Doubler · corrodedINSPECTION FOUND DOUBLER CORRODED AT STA 1338, LONGERON 18L. A NEW SPLICE DOUBLER WAS INSTALLED IAW SRM 51-30-5.SDR CALA9900350Doubler · crackedINSPECTION FOUND A 1 INCH CRACK IN FINGER DOUBLER AT STA 1338, LONGERON 18R JUST FORWARD OF APB T-CAP. A NEW FINGER DOUBLER WAS INSTALLED IAW SRM 51-30-2.SDR CALA9900348Beam · crackedINSPECTION FOUND A .75 INCH CRACK AT BOTH ENDS OF NR 1 BEAM AND A .75 INCH CRACK AT FORWARD END OF NR 4 BEAM OF FORWARD SERVICE DOOR. BOTH BEAMS WERE REPLACED IAW SRM 51-30-2 AND 51-30-3.SDR CALA9900346Bracket · crackedINSPECTION FOUND A 1.5 INCH CRACK IN FORWARD CARGO PIT DOOR BRACKET AT AFT DOOR LATCHING MECHANISM. A NEW BRACKET WAS INSTALLED IAW SRM 51-30.SDR CALA9900342Frame · crackedINSPECTION FOUND A 2.5 INCH CRACK IN FRAME AT L6L AND A 2.5 INCH CRACK WAS FOUND IN FRAME AT L6R, STA 503. THE FRAME WAS REMOVED AND REPLACED IAW SRM 53-03, FIGURE 32.SDR CALA9900341Beam · crackedINSPECTION FOUND A .5 INCH CRACK IN MAIN CABIN DOOR NR 1 BEAM. A NEW BEAM WAS INSTALLED IAW SRM 51-30-1, 51-30-2 AND 51-30-5.SDR CALA9900340Bracket · crackedINSPECTION FOUND A 1 INCH CRACK IN FORWARD CARGO COMPARTMENT DOOR LOWER FORWARD STOP SUPPORT ANGLE BRACKET. THE BRACKET WAS REMOVED AND A NEW BRACKET WAS INSTALLED IAW SRM 51-30.SDR CALA9900338Bracket · crackedINSPECTION FOUND A 1 INCH CRACK IN AFT CARGO DOOR FORWARD LOWER DOOR STOP SUPPORT BRACKET. A NEW BRACKET WAS INSTALLED IAW SRM 51-30.SDR CALA9900334Skin · corrodedINSPECTION FOUND FUSELAGE SKIN CORRODED AT STA 218, LONGERON 30. THE CORROSION WAS REMOVED AND A REPAIR WAS INSTALLED IAW SRM 53-04 FIGURE 44, SHEET 3.SDR CALA9900332Seat Track · corrodedINSPECTION FOUND RT O/B SEAT TRACK CORRODED AT STA 790 TO 805. A NEW SEAT TRACK WAS INSTALLED IAW SRM 51-30-1.SDR CALA9900323Jamb · crackedINSPECTION FOUND A 1.5 CRACK IN AFT ENTRY DOOR JAMB FITTING BETWEEN LONGERON 14L AND 15L, STA 1338. A NEW FITTING WAS INSTALLED IAW SRM 51-30-2.SDR CALA9900316Bracket · crackedINSPECTION FOUND A 1 CRACK IN LEFT WING NR 1 FLAP ACTUATOR FORWARD MOUNT BRACKET. A NEW FLAP MOUNT BRACKET WAS INSTALLED IAW SRM 51-30-5.SDR CALA9900314Seat Track · corrodedINSPECTION FOUND LT CENTER SEAT TRACK CORRODED AT STA 1098. A NEW SEAT TRACK AND SPLICE WERE INSTALLED IAW SRM 51-30-5 AND 53-05.SDR CALA9900313Seat Track · corrodedINSPECTION FOUND LT CENTER SEAT TRACK CORRODED AT STA 1079 TO 1250. A NEW SEAT TRACK AND SPLICE WERE INSTALLED IAW SRM 51-30-5 AND 53-05.SDR CALA9900312Seat Track · corrodedINSPECTION FOUND LT CENTER SEAT TRACK CORRODED AT STA 1212 TO 1221. A NEW SEAT TRACK AND SPLICE WERE INSTALLED IAW SRM 53-05.SDR CALA9900311Doubler · corrodedINSPECTION FOUND WEB AND DOUBLER CORRODED AT STA 1338, LONGERON 30 TO 28R. THE CORRODED SECTION OF WEB WAS CUT OUT, JACK POST DOUBLER WAS REPLACED AND A REPAIR WAS INSTALLED IAW SRM 51-30-0 AND 53-01.SDR CALA9900309Angle · corrodedINSPECTION FOUND AFT BAGGAGE BIN Z-ANGLE CORRODED AROUND HI-LOK FASTENERS. A REPAIR DOUBLER AND SPACER WERE INSTALLED IAW SRM 53-05, FIGURE 63.SDR CALA9900306Seat Track · corrodedINSPECTION FOUND LT I/B SEAT TRACK CORRODED AT STA 1205 TO 1225. THE CORRODED SECTION OF SEAT TRACK WAS REMOVED AND A NEW SECTION WAS INSTALLED IAW SRM 51-30-5 AND 51-30-1.SDR CALA9700448Angle · corrodedINSPECTION FOUND, CORROSION AROUND HI SHEARS ON MID CARGO BIN Z-ANGLE. THE Z-ANGLE WAS REMOVED AND A NEW Z-ANGLE WAS INSTALLED IAW SRM 51-30.SDR CALA9700447Angle · crackedINSPECTION FOUND, A 1 INCH CRACK IN OUTER LEFT DORSAL FIN ATTACH ANGLE ON VERTICAL LEG. A 1 INCH CRACK WAS ALSO FOUND IN INNER LEFT DORSAL FIN ATTACH ANGLE. NEW ATTACH ANGLES WERE INSTALLED IAW ECRA 5340-01290.SDR CALA9700446Pan · crackedINSPECTION FOUND, A 2.5 CRACK IN LT MLG INBOARD DOOR AT OUTBOARD AFT CORNER IN PAN AT DOOR LIP. THE CRACK WAS STOP DRILLED. A DOUBLER WAS INSTALLED IAW SRM 52-05, PAGE 152A AND 51-30-2.SDR CALA9700453Jamb · corrodedINSPECTION FOUND, FORWARD CARGO DOOR LOWER JAMB PAN CORRODED. THE CORRODED AREA OF DOOR JAMB PAN WAS TRIMMED OUT AND A REPAIR WAS INSTALLED IAW ECRA 5310-03452.SDR CALA9700452Beltframe · crackedINSPECTION FOUND, FOUR 1 INCH CRACKS IN CANTED BELTFRAME AT STA 1446, LONGERONS 3R AND 4R. A NEW SECTION OF BELTFRAME WAS INSTALLED IAW SRM 51-30-2 AND 51-30-5.SDR CALA9700451Beltframe · crackedINSPECTION FOUND, EIGHT 1 INCH CRACKS IN CANTED BELTFRAME AT STA 1446, LONGERONS 3L TO 6L. A NEW SECTION OF BELTFRAME WAS INSTALLED IAW SRM 51-30-2 AND 51-30-5.SDR CALA9700450Bulkhead · crackedINSPECTION FOUND, THREE CRACKS IN LOWER FORWARD AREA OF CANTED BULKHEAD, AT STA 1463. THE CRACKS WERE .5 INCH TO 1.5 INCH LONG. A WEB WAS INSTALLED IAW SRM 51-30-05.SDR CALA9700449Spar · crackedINSPECTION FOUND, A .75 INCH CRACK IN RT VERTICAL STABILIZER FRONT SPAR, AT CANTED BULKHEAD STA 1388. THE CRACK WAS LOCATED IN LEG PERPENDICULAR TO WEB OF BULKHEAD. THE CRACKED SECTION OF SPAR WAS REMOVED AND A REPAIR WAS INSTALLED IAW SRM 55-02, PAGE 101.SDR CALA9601647Actuator · shortedSMOKE WITH AN ELECTRICAL ODOR BEGAN COMING FROM CENTER PEDESTAL WHILE INFLIGHT. THE AIRCRAFT WAS RETURNED TO EWR WHERE IT LANDED WITHOUT INCIDENT. MAINTENANCE FOUND THE SPOILER AUTOMATIC ACTUATOR BURNT AND SHORTING. THE SPOILER AUTOMATIC ACTUATOR WAS REMOVESDR CALA9601277Wire · damagedINSPECTION FOUND EMERGENCY AISLE PATH LIGHTING INOPERATIVE AT ROWS 1-6. MAINTENANCE FOUND WIRING IN NEED OF REPAIR. THE WIRING WAS REPAIRED. THE FORWARD CHARGER AND BATTERY PACK WERE ALSO REPLACED. OPERATION OF THE LIGHTS CHECKED GOOD.SDR CALA9601217B-Nut · looseTHE LT HYDRAULIC SYSTEM PRESSURE AND QUANTITY WERE LOST ON APPROACH. THE AIRCRAFT LANDED WITHOUT INCIDENT. MAINTENANCE FOUND A LOOSE B-NUT TO LEFT HYDRAULIC BRAKE VALVE. THE FITTING WAS TIGHTENED AND THE LEFT HYDRAULIC SYSTEM WAS SERVICED, LEAK CHECKS WERE SDR CALA9600965Locking Bolt · shearedINSPECTION FOUND THE HEAD SHEARED OFF OF THE LOWER LOCKING BOLT FOR THE NOSE GEAR SCISSORS. THE NOSE GEAR LOWER TORQUE LINK, PIN AND LOCKING BOLT WERE REMOVED AND REPLACED IAW MM 32-21-04, PAGE 201 TO 206.SDR CAL950608Downlock · inoperativeFLT NR 0364 - EWR - THE RIGHT MLG RED UNSAFE LIGHT ILLUMINATED WHILE ON APPROACH TO EWR. ABNORMAL PROCEDURES WERE COMPLIED WITH DURING A GO AROUND AND THE RED LIGHT EXTINGUISHED. THE AIRCRAFT LANDED WITHOUT INCIDENT. MAINTENANCE FOUND THE RIGHT MLG DOWNLOCKSDR CAL950533Fuel Control · inoperativeEWR - FLT 0400 - THE NR 2 ENGINE PARAMETERS BEGAN TO FLUCTUATE WHEN CLIMB POWER WAS SELECTED. THE AUTO THROTTLE WAS DISCONNECTED, BUT THE PROBLEM REMAINED. THE AIRCRAFT WAS RETURNED TO EWR WHERE IT LANDED WITHOUT INCIDENT. MAINTENANCE FOUND THE NR 2 ENGINE SDR CAL950250Door Pan · crackedHOU - INSPECTION FOUND A 1.5 INCH CRACK IN MAIN CARGO DOOR PAN AT AFT UPPER STOP PAN. THE CRACK WAS STOP DRILLED AND A DOUBLER WAS INSTALLED IAW ECRA 652C0125. (X)SDR CAL950014Switch · inoperativeFLT NR 0356 - EWR - ALL THREE GEAR RED UNSAFE LIGHTS WERE OBSERVED TO BE ILLUMINATED DURING CLIMB-OUT THROUGH 18,000 FEET. CYCLING THE GEAR DID NOT HELP. THE CREW VERIFIED THAT IT WAS AN INDICATION PROBLEM ONLY, AND THAT ALL GEAR WERE UP AND LOCKED. THE FLI
Back to N83873, cancelled Dec 21, 2004