N17356, cancelled Mar 21, 2013
Service difficulty reports · 105
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 = 'N17356' AND deregistration_id = 'N17356-2013-03-21' 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 = 'N17356' AND deregistration_id = 'N17356-2013-03-21' 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 CALA9700095Support · corrodedINSPECTION FOUND CENTER FLOOR RIGHT SUPPORT RAIL CORRODED AT STA 787 TO 807. THE RAIL WAS REPLACED IAW SRM 53-60-53.SDR CALA9700091Skin · crackedINSPECTION FOUND A 7 INCH CRACK IN NR 2 SLAT LOWER SKIN NEAR ACTUATOR. THE SLAT SKIN WAS REPAIRED IAW ECRA 5750-01159.SDR CALA9700078Skin · crackedINSPECTION FOUND A 8.5 INCH CRACK IN LOWER SLAT SKIN NEAR ACTUATOR. THE AREA WAS REPAIRED IAW ECRA 5750-01159.SDR CAL960615Pwr Contl Unit · inoperativeTHE AIRCRAFT EXPERIENCED AN UNCOMMANDED ROLL AFTER TAKEOFF. RIGHT RUDDER INPUT WAS USED TO COUNTER ACT THE MOVEMENT. THE YAW DAMPER SWITCH WAS CONFIRMED ON. THE FLIGHT WAS CONTINUED TO BOS WHERE IT LANDED WITHOUT FURTHER EVENT. MAINTENANCE REMOVED AND REPLSDR CAL950869Circuit Breaker · poppedEWR - FLT 0220 - THE GEAR INDICATOR WOULD NOT GO GREEN WHEN GEAR WAS EXTENDED ON APPROACH TO EWR. THE GEAR WAS VISUALLY CONFIRMED DOWN. IN ADDITION, THE STALL WARNING ACTIVATED AND THE GEAR WARNING HORN SOUNDED WITH FLAPS AT 15 ON FINAL. THE AIRCRAFT LANDED
Back to N17356, cancelled Mar 21, 2013