N625PL
Service difficulty reports not matched to an aircraft · 69
They name N625PL, 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 = 'N625PL' 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 = 'N625PL' 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 CKSA96171Seat Track · corrodedKOSC - DURING C-2 CHECK INSPECTION FOUND: CABIN: SEAT TRACK AT FS 1880 RBL 34 CORRODED. REMOVED CORROSION IAW B747 SRM 51-10-01, FOUND TO BE OUT OF LIMITS. REMOVED AND REPLACED TRACK IAW 51-10-01 AND 51-30-2. CORROSION TASK CARD NR C53-210-01 PART 4 OF 8 TSDR CKSA96170Shear Tie · crackedKOSC - DURING C-2 CHECK INSPECTION FOUND: NR 2 MAIN TANK INTERIOR SHEAR TIE CRACKED WS 670 (FORWARD PYLON INBOARD STRUT SUPPORT APPROXIMATELY 11 INCHES AFT OF FORWARD SPAR) 1.50 INCH CRACK. REPAIRED SHEAR TIE IAW SB 747-57-2273 REV 2 FIGURE 10 AND 11. AD 94-SDR CKSA96169Fitting · crackedKOSC - DURING C-2 CHECK INSPECTION FOUND: CRACK IN RIB SUPPORT FITTING 65B01020-1137 WING STATION 669.5. REPLACED RIB SUPPORT FITTING IAW BOEING 747 SRM 51-10-1 AND 53-30-2. C-CHECK CARD NR 7GK0542. TASK CARD NR 85710.SDR CKSA96168Floor Beam · corrodedKOSC - DURING C-2 CHECK INSPECTION FOUND: MAIN CARGO COMPARTMENT STA 1780 BL-ZERO UPPER CHORD OF FLOOR BEAM HAS EXFOLIATION. REPAIRED IAW B747 SRM 51-40-4 AND 51-50-2. CORROSION CARD NR C53-210-01, PART 4 OF 8. TASK CARD NR 76169.SDR CKSA96167Frame · crackedKOSC - DURING C-2 CHECK INSPECTION FOUND: A PIT STA 880R CRACK IN FRAME ABOVE STA 37R. REPAIRED PER ENGINEERING RESPONSE B405021 AND AIA/E/2345. CORROSION CARD NR C53-110-01. TASK CARD NR 75767.SDR CKSA96166Doubler · disbondedKOSC - DURING C-2 CHECK INSPECTION FOUND: A PIT STA 550R BETWEEN STR 35 AND 36 INNER DOUBLER DISBONDED. REPAIRED INNER DOUBLER IAW B747 SRM 53-30-2 FIGURE 3 AND ENGINEERING RESPONSE B4 05018. CORROSION CARD NR C53-110-01. TASK CARD NR 85605.SDR CKSA96165Frame · crackedKOSC - DURING C-2 CHECK INSPECTION FOUND: APU COMPARTMENT RIGHT DOOR FORWARD LOWER FRAME CRACKED. CLEANED UP OF DAMAGED AREA IAW B747 SRM 52-00-2. C-CHECK CARD NR 7TK0317. TASK CARD NR 85650.SDR CKSA96164Intercostal · crackedKOSC - DURING C-2 CHECK INSPECTION FOUND: APU COMPARTMENT STA 2733 RIGHT SIDE INTERCOSTAL CRACKED 3RD FROM BOTTOM OF FRAME. MANUFACTURED NEW INTERCOSTAL IAW B747 SRM 53-11-24. CLEANED AND TREATED AREA IAW B747 SRM 51-10-02 AND MM 51-21-02. INSTALLED NEW INSDR CKSA96022A12 Card · failedKSUU - APU FIRE WARNING AND MASTER LIGHT WITH BELL WENT OFF, PULLED HANDLE AND DISCHARGED BOTTLE. TROUBLESHOT SYSTEM FOUND A12 AND APU 'LOOP B FIRE' BAD FIRE WARNING NO LONGER USEABLE. TRANSFERRED TO DMI 342 FOR FURTHER TROUBLESHOOTING, PULLED AND COLLARD APSDR CKSA95142Transformer · burnedKLAX - ELECTRICAL SMOKE ODOR IN AREA OF PILOTS MAIN PANEL BACK GROUND RHEOSTAT. PULLED CIRCUIT BREAKER FOR PILOTS BACKGROUND LIGHTING, ODOR DISSIPATED. REMOVED AND REPLACED PILOTS BACKGROUND LIGHT TRANSFORMER. OPS CHECK GOOD IAW 33-10-00. (M)SDR CKSA95106Fire Warn Card · shortedKLAX - APU 'A' LOOP FIRE DETECTOR FLICKERS IN FLIGHT. REMOVED AND REPLACED FIRE WARNING CONTROL CARD AND FIRE DETECTOR CONTROL CARD FOR APU 'A' LOOP SYSTEM. OPS CHECK GOOD IAW B747 MM 26-10-00 AND 26-15-00. DMI NR 248 CLEARED/PLACARD REMOVED. (M)SDR 95ZZZM594Fire Warn Card · shortedKLAX - APU 'A' LOOP FIRE DETECTOR FLICKERS IN FLIGHT. REMOVED AND REPLACED FIRE WARNING CONTROL CARD AND FIRE DETECTOR CONTROL CARD FOR APU 'A' LOOP SYSTEM. OPS CHECK GOOD IAW B747 MM 26-10-00 AND 26-15-00. DMI NR 248 CLEARED/PLACARD REMOVED. REFERENCE NRSDR CKSA95127A5 Circuit Card · shortedNSTU/YMML - FLT 67785 - APU FIRE DETECTOR BLINKS IN-FLIGHT WHEN SELECTED TO BOTH. RESECURED A-5 CIRCUIT CARD FOR APU 'A' FIRE LOOP, OPS CHECK GOOD ON GROUND IAW B747 MM 26-10-00. (X)SDR CKSA95104Connector · looseKLAX - APU FIRE WARNING 'A' DETECTOR LIGHT FLASHED IN FLIGHT BUT NO FIRE WARNING WAS GIVEN. 'B' LOOP FUNCTIONS NORMALLY. LOOSE CONNECTOR ON UPPER FORWARD SENSOR. TIGHTENED AND GROUND CHECKS GOOD IAW MM 26-10-00. (M)SDR CKSA95103A5 Card · shortedKLAX - APU FIRE WARNING 'A' LOOP GIVES INTERMITTENT WARNING DURING FLIGHT WITH APU SHUTDOWN. 'B' CIRCUIT OK. REMOVED AND REPLACED A5 CARD PER MM 26-10-00. OPS CHECK FOUND SATISFACTORY. (M)SDR CKSA95102Fire Warning · malfunctionedPHNL - APU 'A' FIRE WARNING GIVES INTERMITTENT FIRE WARNING IN FLIGHT WITH APU SHUTDOWN. NORMAL OPS ON GROUND. TROUBLESHOT WIRING, COULD NOT DUPLICATE ON GROUND. OPS CHECKED GOOD. (M)SDR CKSA95101Connectors · contaminatedKLAX - APU 'A' FIRE DETECTOR FLICKERED ON AND OFF IN FLIGHT. AURAL WARNING ACCOMPANIED BY FLICKERING LIGHT, SWITCH WAS IN BOTH, SWITCHED TO 'B' PROBLEM WENT AWAY. CLEANED CONTAMINATED CONNECTORS AND RESECURED. OPS CHECK GOOD 26-10-00. (M)SDR CKSA95100A-5 Card · dirtyAPU FIRE WARNING IS INTERMITTENT ON 'A' LOOP. 'B' LOOP OK. CLEANED CONTACTS ON APU FIRE WARNING 'A' LOOP CIRCUIT CARD. OP'S CHECK GOOD ON GROUND. (M)SDR CKSA95006Selector Valve · bypassingSAEZ - FLT 61331 - ON APPROACH, BOTH BODY GEARS AND NOSE GEAR DID NOT EXTEND, WING GEAR OPERATION NORMAL. TRIED MANUAL EXTENSION WITH GEAR HANDLE OFF WITH NO CHANGE. TRIED MANUAL GEAR EXTENSION WITH GEAR HANDLE DOWN AND ALL GEAR OPERATED NORMALLY. REPLACED
Back to N625PL