N639AE
Service difficulty reports · 153
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 = 'N639AE' 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 = 'N639AE' 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 SIMA1361Charger · failedCLE - FLIGHT 4348 - CABIN ENTRY DOOR EMERGENCY FLOOD LIGHT INOPERATIVE. REMOVED AND INSTALL NR 1 EMERGENCY BATTERY CHARGER. OPS CHECK GOOD. (M)SDR SIMA0084Wire · disconnectedORD - FLT 4114 - ROW 12B EMERGENCY LIGHTS INOPERABLE. FOUND GROUNDING POINT DISCONNECTED, RECONNECTED AT GS8522DL. OPS CHECKED GOOD. (X)SDR SIMA993001Solenoid · failedORD - FLT 4245 - LANDING GEAR WOULD NOT RETRACT AFTER TAKEOFF. REMOVED AND REPLACED LANDING GEAR VALVE UP SOLENOID. AIRCRAFT RETURNED TO SERVICE. (X)
Back to N639AE