N31412
Service difficulty reports · 58
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 = 'N31412' 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 = 'N31412' 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 CALA2010070700329Charger · inoperativeEMERGENCY LIGHTS INOP IN FORWARD COACH CABIN. REMOVED AND REPLACED BATTERY PACK AND CHARGER ASSY AT SEAT ROW 8ABC REF AMM 33-51-06. LIGHTS OPS CHECK GOOD M&E 29-3351-3-0013 AND 29-3351-3-0031.SDR CALA2010043000178Battery Pack · dischargedSUPPORT TASK EMERGENCY BATTERY PACK AT SEAT 7ABC FOR THE FLOOR PROX LIGHTS IS DEAD. REPLACED EMERGENCY BATTERY PACK AT SEAT 7ABC FLOOR PROX LIGHTS, OPS CHECK GOOD IAW B737 M/M 33-51-06.SDR CALA2009090800534Floorbeam · corrodedFLOORBEAM STA 344 BL 0 CORROSION IS OUT OF LIMITS. CUT OUT DAMAGE AND REPAIRED FLOORBEAM 344 AT BL 0 WITH FLOORBEAM SPLICE REPAIR REF EC/RA 5321-01687.SDR CALA2009090800533Intercostal · crackedFLOOR INTERCOSTAL CRACKED AFT OF STA 344 AT BL-0. REMOVED OLD AND INSTALLED NEW INTERCOSTAL AT BL 0, BETWEEN STA 344 & STA 360 REF SRM 51-40-02.SDR CALA2009030900129Floorbeam · corrodedCORROSION AT FLOORBEAM STA 986.5 RBL 23 - RBL 29 - RBL 34 HOLES. REPAIRED CORROSION AT FLOORBEAM STA 986.5 RBL - 23, RBL - 29 AND RBL - 34 HOLES PER CAL EC/RA 5321-01429, REPAIR B.SDR CALA0800754Fuse · blownEMERGENCY EXTERIOR LIGHTS AT RIGHT WING AFT DID NOT ILLUMINATE ON TEST. REPLACED FUSE ON BATTERY PACK. OPERATION CHECK NORMAL PER AMM 33-51-06, REPLACE BATTERY PER AMM 33-51-06.SDR CALA0400579Seal · leakingA BURNING ODOR WAS NOTED IN THE CABIN AFTER TAKEOFF FROM EWR. THE AIRCRAFT WAS RETURNED TO EWR WHERE IT LANDED WITHOUT INCIDENT. MAINTENANCE WAS UNABLE TO DETERMINE THE SOURCE OF THE SMELL. IT WAS NOTED THAT THE NR 1 ENGINE UNDERWENT A FAN LUBE WHILE ON RON SDR CALA0400520Trim Switch · faultyTHE ELECTRIC RUDDER TRIM FAILED IN OPERATION TO THE LEFT WHILE IN CRUISE PORTION OF FLIGHT FROM TPA TO EWR. OPERATION TO THE RIGHT WAS NORMAL. IF MOVED TO THE RIGHT THE TRIM COULD NOT BE RETURNED TO THE LEFT AT ALL. THE AIRCRAFT WAS DIVERTED TO MCO WHERE IT
Back to N31412