N507JT
Service difficulty reports · 61
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 = 'N507JT' 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 = 'N507JT' 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 YENA20160913793Seat Track · corrodedSEAT TRACK CORRODED FRAMES 12 - 24 -Y1292R. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-14 REV. 114 TASK 53-00-14-283-002. REPLACED THE SEAT TRACK IAW SRM 51-72-11 AND SRM 51-42-11 REV 114.SDR YENA20160913792Seat Track · corrodedSEAT TRACK CORRODED FRAMES 12-14 Y1292. REMOVED AND REPLACED THE SEAT TRACK IAW SRM 51-72-11, AND 51-42-11.SDR YENA20151204616Battery · inoperativeRIGHT EMERGENCY BATTERY FAULT. R & R RT EMERGENCY BATTERY IAW 33-51-38. OPS CHECK GOOD.SDR YENA20151204615Battery · inoperativeLEFT EMERGENCY BATTERY FAULTED. R & R LT EMERGENCY BATTERY IAW 33-51-38. OPS CHECK GOOD.SDR YENA20150305038Control Unit · failedFLT 198, CREW DECLARED AN EMERGENCY AND AIRCRAFT DIVERTED DUE TO LGCIU FAILURE. REMOVED AND REPLACED LGCIU PER 32-31-71 OPS CHECKED OK FOR SERVICE.SDR YENA20141219281Flap System · malfunctionedEMERGENCY DECLARED. DURING LANDING FLIGHT CONTROL FLAPS LOCKED, SLATS AT 2 FLAPS LESS THAN 1 ON ECAM. UNLOCKED FLAP WING TIP BRAKE AND OPERATED FLAPS SEVERAL TIMES WITH NO FAULTS. PERFORMED INSPECTION OF FLAPS AND DRIVE UNITS, NO DEFECTS FOUND IAW TSM 37-51SDR YENA20141116249Sensor · failedCREW REPORTED NOSE WHEEL STEERING (NWS) FAULT. WILL NOT RESET. LOST ALL STEERING DURING LANDING. ACFT TOWED TO GATE. R & R 3GC NWS FEEDBACK SENSOR IAW AMM 32-51-19. OPS CHECK GOOD.SDR YENA20111012363Light · inoperativeFLT 84 FLL-JFK, FWD, AFT & MID CABIN CEILING LEVEL EXIT IDENTIFIER EMERGENCY LIGHTS & OVER WING EXIT IDENTIFIERS HAS NUMEROUS BULBS INOP. RELAMPED ALL CEILING & OVER WING EXIT IDENTIFIER BULBS AS REQUIRED, OPS CHECK PER AMM 33-51-00.SDR YENA20111012361Light · inoperativeFLT 84 FLL-JFK, ON GROUND MAINTENANCE CHECK FOUND EXIT IDENTIFIER EMERGENCY LIGHTS ON R1, R2, L2 DOORS HAS NUMEROUS BULBS BURNT OUT. EMERGENCY LT TEST FAILED. RELAMPED ALL EXIT IDENTIFIER AS REQUIRED PER AMM 33-51-00. OPS CHECK OK.SDR YENA20110811317Controller · faultyFLT 136 RSW-JFK, DIVERTED TO MCO, DUE TO PACK 1 FAULT AT 30,000 FT. REMOVED AND REPLACED NR 1 PACK CONTROLLER 7HH IAW AMM 21-61-34. OPS CHECK FOUND OK.SDR YENA20110326222Epsu · failedFLT 445 BOS-TPA, ON GROUND AND WHILE PERFORMING EMERGENCY LIGHTS SYS TEST FROM PTP, FOUND EMERGENCY POWER SUPPLY LEFT FAILED. REPLACED EPSU 11WL PER AMM 33-51-38. SYS TEST GOOD.
Back to N507JT