N304TZ
Service difficulty reports not matched to an aircraft · 61
They name N304TZ, 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 = 'N304TZ' 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 = 'N304TZ' 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 AMTA200600168Drive Assy · unserviceableWX FAIL ANT MESSAGE ON CAPTAINS AND FO NAV DISPLAY. REMOVED WX RDR ANT DRIVE IAW MM. OP CHECK GOOD. (K)SDR AMTA200600167Radar · malfunctionedWXR FAIL MESSAGE ON CAPT AND F/O NAV DISPLAY. REPLACED RADAR RT IAW GROUND CHECKS NORMAL. (K)SDR AMTA200600108Warning Light · illuminatedAPU FAIL/FAULT LIGHT ILLUMINATED. (M)SDR AMTA200600079Power Supply · unserviceableRIGHT SIDE, AFT, TWO EXTERIOR EMERGENCY LIGHTS OUT. DURING T/S, FUSE BROKE OFF IN POWER SUPPLY M1695. REMOVED AND REPLACED POWER SUPPLY M1695. ALSO REPLACED BAD FUSE IN POWER SUPPLY M1691. ALSO, REPLACED BAD FUSEL IN POWER SUPPLY M1691 TO FIX INOPERATIVE LSDR AMTA200400161Panel · corrodedFOUND C2 CARGO PANEL CORROSION AT STATION 767 TO 727J. FOUND CORROSION OUT OF LIMITS PER SRM 53-00-53-1. FABRICATED NEW PANEL PER SRM 53-60-53-01 AND INSTALLED PANEL. (M)SDR AMTA200400159Floor Panel · corrodedC-2 CARGO PANELS HAVE CORROSION APPROX STATION 727A TO 727E. FOUND CORROSION OUT OF LIMITS PER SRM 53-00-53-1. REMOVED FLOOR PANEL. FABRIATED AND INSTALLED NEW PANEL. (M)SDR AMTA200400160Floor Panel · corrodedFOUND C-2 CARGO PIT FLOOR PANEL HAS CORROSION STATION 727E TO 727J. CORROSION OUT OF LIMITS PER SRM 53-00-53-01. REMOVED FLOOR PANEL, FABRICATED AND INSTALLED NEW PANEL IAW AMM 51-40-02-0. (M)SDR AMTA200400089Floor Panel · corrodedFOUND C2 CARGO FLOOR PANEL UNDER LOADING SYSTEM CORRODED FROM DOOR FORWARD. REMOVED AND REPLACED CARGO FLOOR PANEL. REINSTALLED ON A/C IAW 737 AMM 25-52-10-4. SEALED FITTINGS IAW 737 AMM 20-30-1 1-2. COATED PANEL WITH ABRASION PROTECTIVE COATING. (M)SDR AMTA200301085Battery · dischargedALL F/A JUMPSEAT EMERGENCY FLASHLIGHT ARE WEAK AND BATTERIES NEED REPLACED. REMOVED AND REPLACED ALL F/A JUMPSEAT EMERGENCY FLASHLIGHTS. OPS NORMAL PER M/M 25-64-00. OK FOR SERVICE. (M)SDR AMTA200301084Battery · dischargedMEGAPHONE IN COMPT 704 NEEDS BATTERIES REPLACED. REMOVED AND REPLACED MEGAPHONE BATTERIES PER MM 25-34-00. OK FOR SERVICE. (M)SDR AMTA200300761Valve · malfunctionedLEFT PACK TRIP LIGHT, WOULD NOT RESET. FOUND ON RECALL. REMOVED AND REPLACED LEFT PACK TCV VALVE PER MM 21-51-10-4. OPS CHECK GOOD. LEAK CHECK GOOD. (M)
Back to N304TZ