N738SK
Service difficulty reports · 160
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 = 'N738SK' 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 = 'N738SK' 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 SWIA200820213Light · inoperativeFLT 5810 - SECOND FROM LAST CEILING LEVEL EMERGENCY FLOOD LIGHT INOP. OPS CHECKS NORMAL.SDR SWIA200718952Floorbeam · crackedFS 280 FORWARD FLOORBEAM IS CRACKED AT LBL10 AND RBL10 RADIUS OF UPPER FLANGE, FOUND AT C-CHECK. INSTALLED FLOOR SUPPORT FOR COCKPIT AT FS 280 PER CRJ7/9 SRM 51-42-06.
SDR SWIA200718951Floorbeam · crackedFOUND AT C-CHECK, FS 280 FLOORBEAM IS CRACKED AT LBL12 AND RBL12. INSTALLED FS280 BEAM AS PER CRJ7/9 SRM 51-42-06 AND 51-42-13 AND LIGHTNING DIVERTER PANELS PER CRJ7/9 SRM 51-41-02.
SDR SWIA200617126Lamp · failedONE FLOOR LEVEL EMERGENCY FLOODLIGHT IS INOP. RELAMPED FLOOR LEVEL EMERGENCY FLOODLIGHT. OPERATIONAL CHECKS GOOD.SDR SWIA200617074Casting · crackedFWD SIDE PAX DOOR CRACKED/HANDRAIL HOLDDOWN CASTING, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PAARTS -1;-2;-3 TO FWD SIDE PANEL OF PAX DOOR PER CRJ 700 SRM 51-42-06 P7.SDR SWIA200617073Panel · crackedAFT SIDE PAX DOOR CRACKED HANDRAIL HOLDDOWN;PC7029 CASTING, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS TO AFT SIDE PANEL OF PAX DOOR PER CRJ 700 SRM 51-42-06-P7.SDR SWIA200616769Battery Pack · dischargedLOWER RIGHT EMERGENCY EXIT LIGHT ROW 12 IS INOP. REPLACED NR 3 ELBP. OPERATIONAL CHECKS GOOD, IAW 33-00-00.SDR SWIA200616757Light · inoperativeBOTTOM EMERGENCY LIGHT INOP BY GALLEY DOOR. RELAMPED BOTTOM EMERGENCY LIGHT. OPERATIONAL CHECKS GOOD.SDR SWIA200616672Control Unit · failed"SPLR/STAB FAULT" MESSAGES. INSTALLED SERVICEABLE NR 2 SSCU IAW MM 27-61-05. OPERATIONAL CHECKS GOOD, P/N:C13045BA04 S/N ON: 865 S/N OFF: 844.SDR SWIA200514672Light · brokenRIGHT LOWER EMERGENCY FLOOD LIGHT NEXT TO SERVICE DOOR IS BROKEN. REMOVED AND REPLACED EMERGENCY FLOOD LIGHT FIXTURE ON AFT GALLEY PARTITION. OPERATIONAL CHECK GOOD.
Back to N738SK