N77303, cancelled Mar 21, 2013
Service difficulty reports · 53
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 = 'N77303' AND deregistration_id = 'N77303-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 = 'N77303' AND deregistration_id = 'N77303-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 CALA9700503Battery Pack · dischargedTHE OVERHEAD EMERGENCY LIGHT AT ROWS 15 TO 23 LEFT DID NOT REMAIN ILLUMINATED FOR AT LEAST 15 MINUTES. THE BATTERY PACK WAS REPLACED AND FUNCTIONAL TEST WAS GOOD.SDR CALA9700502Battery Pack · dischargedTHE OVERHEAD EMERGENCY LIGHT AT ROW 14 RIGHT DID NOT REMAIN ILLUMINATED FOR AT LEAST 15 MINUTES DURING TEST. THE BATTERY PACK WAS REPLACED AND FUNCTIONAL TEST WAS GOOD.SDR CAL950269Eel Batt Charger · inoperativeHOU - THE FWD ENTRY DOOR EMERGENCY EXIT LIGHT FAILED TO ILLUMINATE DURING A SCHEDULED MAINTENANCE TEST. THE BATTERY CHARGER AND BATTERY PACK WERE REMOVED AND REPLACED. OPERATION OF THE EMERGENCY EXIT LIGHT WAS RESTORED. (W)
Back to N77303, cancelled Mar 21, 2013