N602CZ
Service difficulty reports not matched to an aircraft · 117
They name N602CZ, but no registry record covers the date, the aircraft registered then was built later, or the report describes another aircraft. 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 = 'N602CZ' AND registry_match IS NULL 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 = 'N602CZ' AND registry_match IS NULL 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 C77A20130430015Finger Doubler · corrodedFORWARD CARGO DOOR THRESHOLD AFT FINGER DOUBLER,HAS CORROSION AT X=8400-8753 Y=300. R & R AFT FINGER DOUBLER IAW SRM 51-41-01 AND 51-43-01.SDR C77A20130430014Finger Doubler · gougedFWD CARGO DOOR THRESHOLD FWD FINGER DOUBLER, PN 170-67115-001 IS GOUGED AT X =7662.2 Y=390. R & R FWD FINGER DOUBLER IAW SRM 51-41-01 AND 51-43-01 ON WO 670776-128 IAW COMPASS EO E175-53MR-136, REV IR WO 724164.SDR C77A20130430013Threshold · corrodedFORWARD CARGO DOOR CUTOUT THRESHOLD FLOORBEAM,HAS CORROSION AT X=7620 - 8450 STR 26R. R & R THRESHOLD FLOORBEAM IAW SRM 51-41-01 AND 51-43-01.SDR C77A20130430012Seal Depressor · corrodedFORWARD CARGO DOOR CUTOUT CENTER SEAL DEPRESSOR PN 170-66804-401 HAS CORROSION AT X=8038.2 STR 26R. R & R CENTER SEAL DEPRESSOR IAW SRM 51-41-01 AND 51-43-01.SDR C77A20130430011Seal Depressor · corrodedFORWARD CARGO DOOR CUTOUT FWD SEAL DEPRESSOR, HAS CORROSION AT Y=7668 STR 24R-26R. R & R FWD SEAL DEPRESSOR IAW SRM 51-41-01 AND 51-43-01 ON WO 670776-129 IAW COMPASS EO E175-53MR-108, REV 2, WO 718879.SDR C77A20130430010Gusset · corrodedRT INBD GUSSET, AT FRAME 90 HAS CORROSION. X=24868, Y=260.4, R & R RT INBD GUSSET IAW SRM 51-41-01 AND 51-43-01.SDR C77A20130430009Gusset · corrodedRT OTBD GUSSET, AT FRAME 90 HAS CORROSION AT X=24868, Y=584.2. R & R RT OTBD GUSSET IAW SRM 51-41-01 AND 51-43-01.SDR C77A20130430008Floor Support · corrodedRT FLOOR SUPPORT, HAS CORROSION AT X=24485.6, Y=914.4. R & R RT FLOOR SUPPORT IAW SRM 51-41-01 AND 51-43-01.SDR C77A20130430007Shear Plate · corrodedRT SHEAR PANEL, HAS CORROSION ALONG FOWARD RIVET ROW AT X=23865, Y=304.8 - 863.6. R & R RT SHEAR PANEL IAW SRM 51-41-01 AND 51-43-01.SDR C77A20130430006Shear Plate · corrodedAFT CABIN CENTER SHEAR PANEL, HAS CORROSION ALONG FORWARD RIVET ROW AT X=23865 , Y= -241.3 TO +241.3. R & R RT CENTER SHEAR PANEL IAW SRM 51-41-01 AND 51-43-01.SDR C77A20130430005Upper Sheet · corrodedAFT CABIN RT UPPER SHEET HAS CORROSION ON THE UPPER SURFACE BETWEEN FRAMES 85 AND 86. X=23041-23453 Y=260.4. R & R RT UPPER SHEET IAW SRM 51-41-01 AND 51-43-01 ON WO 670776-110 IAW COMPASS EO E175-5300-092, REV IR WO720650.SDR C77A20130430004Floor Support · corrodedAFT CABIN RT FLOORBEAM, CORRODED THROUGH AT TWO POINTS BETWEEN FRAMES 86 AND 87. X= 23453 - 22365 Y+ 260.4. R & R RT FLOORBEAM IAW SRM 51-41-01 AND 51-43-01.SDR C77A20130430003Seat Track · corrodedSEAT TRACK, HAS CORROSION AT X=4799 Y=260.4. REMOVED CORROSION IAW SRM 51-10-03 & 51-12-01 AND INSTALLED DOUBLERS IAW 2013-170-006436-C AND EO E175-53MR-135 REV IR.SDR C77A20130430002Floorbeam · corrodedFWD FLOORBEAM, RT SIDE HAS CORROSION AT X=4270.0, Y=310. CUTOUT CORRODED TOP CAP AND INSTALL FILLER, 2 "L" ANGLE DOUBLERS IAW 2013-170-006436-C AND EO E175-53MR-135, REV IR.SDR C77A20130430001Floor Support · corrodedRT FWD FLOOR SUPPORT CORRODED X=4270 Y=1192. R & R RT FLOOR SUPPORT IAW SRM 51-41-01 AND 51-43-01.SDR C77A20130426001Battery Pack · failedFWD RT LOWER RED EMERGENCY EXIT SIGN DOES NOT ILLUMINATE DURING FUNCTIONAL CHECK. REPLACED BATTERY PACK.SDR C772008F00001Counterbalance · inoperativeL1 DOOR WAS FOUND TO BE HARD TO OPEN AFTER FLT 2068 ON 8/27//2008. FOUND COUNTERBALANCE RODS WEAK IN L1 DOOR. WILL BE REPLACING WITH NEW ONE. (K)
Back to N602CZ