N675BR
Service difficulty reports · 72
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 = 'N675BR' 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 = 'N675BR' 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 COMA2009100150192Oil System · overservicedON CLIMBOUT FROM CVG RECEIVED HIGH OIL TEMP ON RIGHT ENGINE. PERFORMED QRH, EMERGENCY DECLARED, A/C RETURNED TO CVG LANDED SAFELY. INSPECTED A/C FOUND RIGHT ENGINE OIL TANK OVER SERVICED. SERVICED OIL TANK TO CORRECT LEVEL, GROUND RUNS GOOD.SDR COMA0860073Actuator · faultyFLIGHT 4940 - FLAPS FAILED AT 0 DEGREES ON APPROACH TO YUL. EMERGENCY DECLARED, AIRCRAFT LANDED SAFELY. REMOVED AND REPLACED RIGHT I/B FLAP I/B ACTUATOR.SDR COMA0860072Actuator · faultyFLIGHT 4940 - FLAPS FAILED AT 0 DEGREES ON APPROACH TO YUL. EMERGENCY DECLARED, AIRCRAFT LANDED SAFELY. REMOVED AND REPLACED RIGHT I/B FLAP O/B ACTUATOR.SDR COMA0860070Flap · malfunctionedFLIGHT 5492 - FLAPS FAIL CAUTION MESSAGE RECEIVED WHEN SELECTING FLAPS TO 8 DEGREES, FLAPS REMAINED AT 0 DEGREES. EMERGENCY DECLARED AND AIRCRAFT LANDED SAFELY. COMPLIED WITH TASK CARD SI-2-27I001, FLAPS FAIL FIRST EVENT MAINTENANCE ACTION.SDR COMA0860023Flex Drive · faultyFLIGHT 5391- RECEIVED FLAP FAIL MESSAGE. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. REPLACED LEFT SIDE NR 5 FLAP FLEX DRIVE. NO FURTHER DEFECTS.SDR COMA0860022Flex Drive · faultyFLIGHT 5391 - RECEIVED FLAP FAIL MESSAGE. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. REPLACED LEFT SIDE NR 3 FLAP FLEX DRIVE. NO FURTHER DEFECTS.SDR COMA0860021Flex Drive · faultyFLIGHT 5391 - RECEIVED FLAP FAIL MESSAGE. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. REPLACED RIGHT SIDE NR 2 FLAP FLEX DRIVE. NO FURTHER DEFECTS.SDR COMA0860020Actuator · contaminatedFLIGHT 5391 - RECEIVED FLAP FAIL MESSAGE. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. REPLACED LEFT SIDE NR 2 FLAP ACTUATOR, DUE TO WATER CONTAMINATION. NO FURTHER DEFECTS.SDR COMA0760632Flap System · malfunctionedFLIGHT 5620 - EN ROUTE CVG-YUL RECEIVED FLAP FAIL MESSAGE. DECLARED EMERGENCY, LANDED WITHOUT INCIDENT. COMPLIED WITH AD 2006-12-21 FLAP CAUTION MESSAGE -FIRST EVENT- MAINTENANCE ACTION, PARAGRAPH (G) 1, 2, 3 (A, B, C) FLAP SYSTEM WAS RESET WITH NO FURTHER MSDR COMA0760078Actuator · faultyFLIGHT 5425 - RECEIVED FLAP FAIL CAUTION MESSAGE. DIVERTED FROM LGA TO JFK. LANDED WITHOUT INCIDENT. REPLACED RIGHT OUTBOARD FLAP OUTBOARD ACTUATOR. NO FURTHER DEFECTS.SDR 05048675Shaft · damagedEVENT SUMMARY STATED FLAPS FAIL AT 0 DEG ON APPROACH. REMOVED AND REPLACED LT FLAP FLEX SHAFT.SDR 05032675Wire · damagedAFT SECTION OF EMERGENCY LIGHTING INOP. REPLACED POWER SUPPLY CABLE AND LIGHTING STRIP.SDR 05029675Gcu · defectiveGENERATOR 2 TRIPPED ON TAXI OUT. MAINTENANCE REMOVED AND REPLACED GCU.SDR 04304675Fcu · failedEVENT SUMMARY STATED THAT AFTER TAKEOFF FLAP FAIL INDICATION RTF. REMOVED AND REPLACED FECU MM 27-51-05.SDR 04160675Bulb · burned outDURING INSPECTION THE PASSENGER DOOR EXTERIOR EMERGENCY LAMP WAS FOUND INOPERATIVE. THE BULB WAS REPLACED AND A SATISFACTORY OPERATIONAL CHECK WAS PERFORMED. AIRCRAFT WAS RETURNED TO SERVICE.SDR 04132675Bulb · burned outDURING INSPECTION THE LEFT HAND FORWARD EMERGENCY LIGHT WAS FOUND INOPERATIVE. THE BULB WAS REPLACED AND A SATISFACTORY OPERATIONAL CHECK WAS PERFORMED. AIRCRAFT WAS RETURNED TO SERVICE.SDR 04030675ABulb · burned outDURING INSPECTION THE RIGHT HAND EMERGENCY EXTERIOR LIGHT WAS FOUND INOPERATIVE. THE BULB WAS REPLACED AND A SATISFACTORY OPERATIONAL CHECK WAS PERFORMED. AIRCRAFT WAS RETURNED TO SERVICE.SDR 04030675Bulb · burned outDURING INSPECTION A CEILING EMERGENCY LIGHT WAS FOUND INOPERATIVE. THE BULB WAS REPLACED AND A SATISFACTORY OPERATIONAL CHECK WAS PERFORMED. AIRCRAFT WAS RELEASED FOR SERVICE.SDR 03354675Light · inoperativeDURING INSPECTION THE RT EMERGENCY LIGHT WAS FOUND INOPERATIVE. THE BULB WAS FOUND BURNT OUT AND WAS REPLACED. A SATISFACTORY OPERATIONAL CHECK WAS PERFORMED AND AIRCRAFT WAS RELEASED FOR CONTINUED SERVICE.SDR 03315675Display · failedDURING FLIGHT CREW REPORTED THE NR 2 MULTI FUNCTION DISPLAY FAILED. NO EMERGENCY WAS DECLARED AND FLIGHT LANDED UNEVENTFULLY. THE DISPLAY UNIT WAS IDENTIFIED AS THE CAUSE OF THE FAULT AND WAS REPLACED. A SATISFACTORY OPERATIONAL CHECK WAS PERFORMED AND AIRCSDR 03190675Lamp · inoperativeDURING MAINTENANCE INSPECTION, AN INTERIOR EMERGENCY EXIT LIGHT WAS FOUND TO BE INOPERATIVE. MAINTENANCE PERSONNEL REMOVED AND REPLACED THE LAMP IN THE EMERGENCY EXIT LIGHT. AN OPERATIONAL CHECK WAS SATISFACTORY AND THE AIRCRAFT WAS RETURNED TO SERVICE.SDR 03134675Line · leakingDURING THE CLIMB, THE CREW REPORTED THAT THE HYDRAULIC NR 3 PRESSURE DROPPED TO ZERO WITH A GEAR DISAGREE MESSAGE AND A "HYD3A" MESSAGE. THE FLIGHT RETURNED TO ORD, LANDED WITHOUT FURTHER INCIDENT, AND WAS TOWED TO THE GATE. MAINTENANCE PERSONNEL REMOVED AND
Back to N675BR