N644UA
Service difficulty reports · 376
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 = 'N644UA' 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 = 'N644UA' 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 CALA2017091503186Bulb · inoperativeEMERGENCY LIGHTS DISARMED LIGHT BULB INOPERATIVE. REPLACED THE BULB. OPS NORMAL.SDR CALA2017081802728Spar · crackedNR 2 PYLON UPPER SPAR WEB FOUND CRACKED AT HYD CASE DRAIN TUBE THROUGH CUTOUT. REPAIR ACCOMPLISHED IAW EC/RA 5410-01857, REV-, PART 1, STEP 1.SDR CALA2017081802726Skin · wornWEAR ON EXTERIOR LT FUSELAGE SKIN AT VERTICAL STABILIZER TO FUSELAGE INTERFACE AREA BS 1582 TO 1605.5. INTERIM REPAIR ACCOMPLISHED IAW ECRA 5330-06139, PART 1, STEP 1.SDR CALA2017081802725Frame · corrodedAFT BULKHEAD LOWER SUPPORT FRAME SURFACE AT BS 1584, LBL 10 FOUND CORRODED. INTERIM REPAIR ACCOMPLISHED IAW PART 1, STEP 1, IAW ECRA 5310-07 168.SDR CALA2017081802724Skin · damagedWEAR MARK ON EXTERIOR RT FUSELAGE SKIN AT VERTICAL STABILIZER TO FUSELAGE INTERFACE AREA BS 1582 - 1605.5. INTERIM REPAIR ACCOMPLISHED IAW ECRA 5330-06139, PART 1, STEP 1.SDR CALA2017081802720Skin · scratchedLOWER EMPENAGE SKIN BS 1788 - 1809 STRINGER 30 - 32L, FOUND SCRATCHED. REPAIRED IAW SRM 53 -00-01, REPAIR 6, FIG 201.SDR CALA2017080802510Failsafe · corrodedAFT OF BULK CARGO BAY SUPPORT FRAME LOWER FAIL SAFE AT BS 1562, BL 0, FOUND CORRODED. INTERIM REPAIR ACCOMPLISHED IAW ECRA 5310-07173, PART 1, STEP 2.SDR CALA2017080802481Stringer · crackedFWD CARGO BAY LOWER DOOR SILL UPPER STRINGER FOUND CRACKED. THE STRINGER WAS REPLACED IAW SRM 51-10-02 AND AMM 20-11-00.SDR CALA2017080802480Web · corrodedBULK CARGO BS 1576, BL 0 BILGE, VERTICAL SUPPORT FACE FOUND CORRODED. THE VERTICAL SUPPORT WEB AND TWO ANGLES REPLACED IAW SRM 51-10-02, AND INSTALLED IAW SRM 51-4 0-02.SDR CALA2017080802473Failsafe · corrodedFWD CARGO BAY DOOR SILL LOWER STRINGER LOWER FAIL SAFE STRAP FOUND CORRODED AT BS 566. THE FAIL SAFE STRAP WAS REPAIRED IAW ECRA 5310-07172, REV.SDR CALA2017080802470Panel · corrodedFWD CARGO BAY RT TORQUE PANEL HAD SURFACE CORROSION AT BS 544. THE TORQUE PANEL WAS REPLACED.SDR CALA2017073102460Angle · corrodedFWD CARGO BAY 5C POWER DRIVE UNIT AFT ANGLE SURFACE FOUND CORRODED. THE AFT ANGLE WAS REPLACED IAW SRM 51-10-02, AND SRM 51-40-02.SDR CALA2017073102459Shear Web · corrodedFWD CARGO BAY 4R POWER DRIVE UNIT ATTACH SHEAR WEB FOUND CORRODED. REPLACED IAW SRM 51-10-02 AND SRM 51-40-02.SDR CALA2017073102458Stringer · corrodedFWD CARGO DOOR SILL LOWER STRINGER WAS FOUND CORRODED AT BS 478 - 610. THE STRINGER WAS REPLACED IAW SRM 51-10-02 AND SRM 51-40-02.SDR CALA2017072802391Floorbeam · corrodedCABIN BS 287, RBL 37-76 FLOORBEAM FOUND CORRODED. REPAIRED IAW SRM 53-00-51, REPAIR 1, FIG 201.SDR CALA2017072802390Nut Plate · corrodedFWD CARGO BAY 8R POWER DRIVE UNIT AFT NUT PLATE AREA FOUND CORROSION FWD CARGO COMPT 8R POWER DRIVE UNIT AFT SUPPORT WEB REPLACED IAW SRM 51-10-02 AND INSTALLED IAW SRM 51-40-02.SDR CALA2017072402345Channel · corrodedFWD CARGO BAY PDU 7R INBD MOUNTING SUPPORT CHANNEL FOUND CORRODED AT BS 544 - 566. THE SUPPORT CHANNEL WAS REPLACED IAW SRM 51-10-02, AND SRM 51-40-02.SDR CALA2017072402344Support · corrodedFWD CARGO BAY BS 566 - 577, RBL 37 TORQUE PANEL OTBD LOWER SUPPORT FOUND CORRODED. REPLACED IAW SRM 51-10-02 AND SRM 51-40-02.SDR CALA2017072402343Web · corrodedSUPPORT WEB FOUND CORRODED AT FWD CARGO BS 456 - 478, RBL 40. THE SUPPORT WEB WAS REPLACED IAW SRM 51-10-02 AND SRM 51-40-02.SDR CALA2017072102297Floorbeam · corrodedM/D AFT ZONE BS 1482, RBL 54 FLOORBEAM UPPER TEE CORRODED. REPAIRED IAW SRM 53-00-51, REPAIR 2, FIG 201.SDR CALA2017072102296Floor Support · corrodedFLOOR SUPPORT CORRODED BS 786 - 890, RBL 54. REPAIRED IAW SRM 53-00-51, FIG 201, REPAIR 3.SDR CALA2017072102295Floorbeam · corrodedFWD CARGO BAY FLOORBEAM FOUND ANCHOR NUTS AREA CORRODED, BS 632 LBL 18 - 28. REPAIRED IAW SRM 51-10-02 AND SRM 51-40-02.SDR CALA2017072102292Stringer · crackedFOUND STRINGER 9L, BS 1439 CRACKED, REPAIRED THE STRINGER IAW SRM 53-00-03, FIG 201, REPAIR 1.SDR CALA2017072102290Angle · corrodedFWD CARGO BAY FWD OF PDU 8R INBD SUPPORT ANGLE FOUND CORRODED, LOWER SURFACE BS 566 - 588, RBL 24. THE ANGLE WAS REPLACED IAW SRM 51-10-02 AND SRM 51-40-02.SDR CALA2017072102289Skin · corrodedDEEP BLEND OUT UNDER LOCK FASTENER HEAD EXPOSING PART OF COUNTERSINK THAT HAS LIGHT CORROSION UNDERNEATH ON UPPER FUSELAGE CROWN SKIN BS 1307 JUST OUTBOARD OF STRINGER 1R REPAIRED THE SKIN IAW SRM 53-00-01, REPAIR 29, FIG 201SDR CALA2017071402213Support Channel · corrodedFWD CARGO BAY TORQUE BOX PANEL SUPPORT CHANNEL FOUND CORRODED AT BS 478 - 500. REPLACED IAW SRM 51-10-02, AND SRM 51-40-01.SDR CALA2017071402212Web · corrodedFWD CARGO BAY BS 478 TO 497, RBL 30 FLOOR SUPPORT WEB FOUND CORRODED. REPLACED IAW SRM 51-10-02, AND SRM 51-40-02.SDR CALA2017071402211Floor Support · corrodedFWD CARGO BAY BS 588 TO 610, RBL 33 FLOOR SUPPORT FOUND CORRODED. REPLACED IAW SRM 51-10-02 AND SRM 51-40-02.SDR CALA2017071402210Floor Support · corrodedFWD CARGO BAY BS 583, RBL 33 FLOOR SUPPORT FOUND CORRODED. REPLACED IAW SRM 51-10-02, AND SRM 51-40-02.SDR CALA2017071402209Shear Tie · corrodedAFT OF BULK CARGO COMPT - SHEAR TIE FOUND CORRODED AT BS 1540, STRINGERS 39L - 39R, THE SHEAR TIE WAS REPLACED IAW SRM 51-10-02 AND SRM 51-40-02.SDR CALA2017071402208Channel · corrodedFWD CARGO BAY PDU 4R AFT SUPPORT MOUNTING SUPPORT CHANNEL FOUND CORRODED BS 500. REPLACED IAW SRM 51-10-02, AND SRM 51-40-02.SDR CALA2017071402207Floor Support · corrodedFWD CARGO FLOOR SUPPORT FOUND CORRODED BS 502.51, RBL 38. REPLACED IAW SRM 51-10-02, AND SRM 51-40-02.SDR CALA2017071402206Floor Support · corrodedFWD CARGO BAY BS 544 - 566, RBL 36 FLOOR SUPPORT CORRODED. REPLACED IAW SRM 51-10-02 AND SRM 51-40-02.SDR CALA2017071402205Cover · crackedFWD CARGO BAY PDU 3R OTBD SUPPORT PLATE COVER FOUND CORRODED AND CRACKED. REPLACED IAW SRM 51-10-02 AND SRM 51-40-02.SDR CALA2017071402204Floor Support · corrodedFWD CARGO FLOOR SUPPORT UPPER SURFACE WAS CORRODED AT BS 512.15, RBL 38. REPLACED IAW SRM 51-10-02 AND SRM 51-40-02.SDR CALA2017071402203Floor Support · corrodedFWD CARGO BAY BS 524 TO 541, RBL 33 FLOOR SUPPORT FOUND CORRODED. REPLACED IAW SRM 51-10-02 AND SRM 51-40-02.SDR CALA2017071402190Intercostal · corrodedFWD CARGO BAY PDU 7R OTBD AFT MOUNTING LOWER INTERCOSTAL FOUND CORRODED. THE INTERCOSTAL WAS REPLACED IAW SRM 51-10-02 AND INSTALLED IAW SRM 51-40-02SDR CALA2017071402202Support · corrodedFWD CARGO BAY BS 520, RBL 42 LATERNAL SUPPORT OTBD FOUND CORRODED AT THE DOOR SILL. REPLACED IAW SRM 51-10-02 AND SRM 51-40-02.SDR CALA2017071402201Support Angle · corrodedFWD CARGO BAY BS 512 - 519, RBL 40 NO. 5R PDU OTBD MOUNTING SUPPORT ANGLE FOUND CORRODED. THE MOUNTING SUPPORT ANGLE WAS REPLACED IAW SRM 51-10-02, AND SRM 51-40-02.SDR CALA2017071402200Floor Support · corrodedFWD CGO COMPT BS 522 TO 544, RBL 24.75 FLOOR SUPPORT WAS FOUND CORRODED. THE FLOOR SUPPORT WAS REPLACED IAW SRM 51-10-02, AND INSTALLED IAW SRM 51-40-02.SDR CALA2017071402199Floor Support · corrodedFWD CARGO BAY BS 478 TO 500, RBL 23 FLOOR SUPPORT FOUND CORRODED. THE FLOOR SUPPORT WAS REPLACED IAW SRM 51-10-02, AND INSTALLED IAW SRM 51-40-02.SDR CALA2017063002019Skin · corrodedDEEP BLEND OUT UNDER LOCK FASTENER HEAD EXPOSING PART OF COUNTERSINK THAT HAD LIGHT CORROSION UNDERNEATH ON UPPER SURFACE FUSELAGE CROWN SKIN BS 1307 OTBD OF STRINGER 1R. THE AREA WAS REPAIRED IAW SRM 53-00-01, RPR 29, FIG 201.SDR CALA2017063002018Skin · scratchedBS 654+30 - 654+36, STRINGERS 4L - 5L SKIN FOUND SCRATCHED. THE SKIN WAS REPAIRED IAW SRM 53-00-01, REPAIR 14, FIG 201.SDR CALA2017050501250Splice · chafedLT ENG FUEL FILTER EICAS. EMERGENCY DECLARED. FOUND WIRE W3508-005-18 PIN A ON CONNECTOR D10996 CHAFING TO GRD ON AN EXISTING SPLICE 24 INCHES FROM PLUG D4232P. REMOVED AND REPLACED DAMAGED SPLICE IAW SWPM 20-10-13, 20-30-12 & WDM 73-34-11. PERFORMED HIGH POSDR CALA2017050501237Pressure Switch · faultyAT TOP OF CRUISE GOT A L ENG FUEL FILTER EICAS. EMERGENCY DECLARED. T/S PER FIM 73-34 FAULT TREE 803. CHANGED NR 1 ENG FUEL FILTER REF AMM 73-11-02. LEAK CHK GOOD. MSG DID NOT RETURN ON IDLE RUN. R&R NR 1 ENG FUEL PUMP DIFFERENTIAL PRESSURE SWITCH PER AMM 73-3SDR CALA2017042101092Lens · brokenEMERGENCY EXIT LIGHT LENS IS BROKEN AT SEAT 20J. INSTALLED NEW EMERGENCY EXIT LIGHT LENS.SDR CALA2017021000314Pin · looseEMER LIGHT AT SEAT 39J INOP WHEN TESTED. ADDITIONAL EMERGENCY LIGHTS INOP AT SEATS 27J, 28J, AND 34J RELAMPED, NO HELP. LIGHT SOCKET TESTED OK. SECURED LOOSE EMERGENCY SEAT LIGHT CONNECTIONS AT 27J, 28J AND 34J, FOUND PUSHED PIN AT SEAT LIGHT CONNECTOR FOR 39JSDR CALA2017020300251Lamp · looseMID LEFT SIDE FWD EMERGENCY EXIT DOOR LAMP OUT. REPOSITIONED THE LAMP, OPS CHECKED GOODSDR CALA2016100700724Skin · puncturedLEFT INBD ELEVATOR UPPER SURFACE PUNCTURED. REPAIRED IAW ECRA5520-01503.SDR CALA2015101294578Failsafe · corrodedMAJOR REPAIR, AFT PIT STATION 1562 FAIL SAFE STRAP WAS FOUND CORRODED, BETWEEN STRINGER 38L & 38R. REPAIR WAS ACCOMPLISHED IAW ECRA 5362-01030.
Back to N644UA