N57FB, cancelled Nov 4, 2013
Service difficulty reports · 17
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 = 'N57FB' AND deregistration_id = 'N57FB-2013-11-04' 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 = 'N57FB' AND deregistration_id = 'N57FB-2013-11-04' 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 ARWA0010101Hydraulic Line · leakingDURING DESCENT AT THE INITIAL PHASE OF THE APPROACH LOSS HYDRAULIC FLUID AND PRESSURE. INITIATED PHASE I AND ABNORMAL IAW PROCEDURES. AFTER CLEARING THE ACTIVE DURING TAXI, LOSS HYDRAULIC BRAKE PRESSURE. AIR BRAKE PRESSURE APPLIED. FOUND PRESSURE LINE TO ESDR ARWA0001004Pin · brokenFLIGHT LEAVING OUT OF MIA TO KM, WHEN LANDING GEAR SELECTED UP; CREW HEARD LOUD BANG IN AFT AIRCRAFT; FOLLOWED BY UNSAFE RED GEAR LIGHT AND LOSS OF HYDRAULIC FLUID. FOUNDED LT MAIN GEAR RETRACTING ACTUATOR BROKEN PIN. DURING REPLACEMENT OF THE LT RETRACT PIN SDR ARWA0001003Panel · corrodedDURING B CHECK INSPECTION, FOUND THE FOLLOWING: CORROSION ON LT WING UPPER INNER WING L/E SLANT PANEL. REPAIR CORROSION CRACK IAW EO 0010181.SDR ARWA0001002Longeron · corrodedDURING B CHECK INSPECTION, FOUND THE FOLLOWING: CORROSION CRACK AT LONGERON L-24 BETWEEN FS 960 AND 980. REPAIRED CORROSION CRACK IAW BOEING MESSAGE INW-LIM-00-00142H.SDR ARWA0001001Skin · corrodedDURING B CHECK INSPECTION FOUND THE FOLLOWING:CORRODED C3 CARGO DOOR LOWER EDGE OUTER SKIN BETWEEN BS 1130 AND BS 1160. REPAIRED CORROSION CRACK IAW DRAWING AS1121-IR.SDR 2000ZZZX465Skin · corrodedDURING B-CHECK INSPECTION, FOUND THE FOLLOWING: 4.5 INCH CRACK IN RIGHT INBOARD FORWARD LOWER WING SKIN AT STA XRS 210 BETWEEN 66 AND 67. REPAIRED CRACK IAW BOEING SERVICE ENGINEERING ROD SKETCH 99-08-13 AND SRM 57-2-1 FIGURE 35, FINE AIRLINES EA G5730-02:00SDR 99ZZZM231Switch · failedDURING CRUISE GEAR UNSAFE LIGHT ILLUMINATED. CYCLED GEAR AND RECEIVED THREE GREEN LIGHTS FOR LANDING GEAR. LANDED AT MIA WITHOUT INCIDENT. GROUND INSPECTION REVEALED RIGHT MAIN LANDING GEAR DOOR NOT FULLY CLOSED. REPLACED LEFT AND RIGHT DOOR MICROSWITCHES, LSDR 2000ZZZX467Floorbeam · corrodedDURING C-CHECK INSPECTION, FOUND THE FOLLOWING: FLOORBEAM CORRROSION DAMAGE AT STA FS 940. REPAIRED CORROSION DAMAGE IAW FINE AIRLINES EO 9810211. (X)SDR 2000ZZZX466Floorbeam · corrodedDURING C-CHECK INSPECTION, FOUND THE FOLLOWING: FLOORBEAM CORRROSION DAMAGE AT STA FS 820 - FS 859, LEFT. REPAIRED CORROSION DAMAGE IAW FINE AIRLINES EO 9810161. (X)SDR 98ZZZM176Link · brokenAFTER TAKEOFF SJU, EXPERIENCED VIBRATION AND NOISE IN NOSE WHEEL WELL AREA. RETURNED TO SJU AND LANDED WITHOUT INCIDENT. FOUND LEFT NOSE GEAR DOOR OPEN AND DOOR LINK BROKEN. REPLACED DOOR LINK AND DOOR OP CHECKED NORMAL.SDR 97ZZZM908Connector · wire looseIN CLIMB-OUT OF BOGOTA, EXPERIENCED FIRE WARNING LIGHT AND BELL. SHUT DOWN NR 1 ENGINE AND FIRE WARNING CEASED. GROUND INSPECTION REVEALED A BROKEN WIRE AT THE CANNON PLUG AT THE LEFT AFT COWL DOOR. REPAIRED WIRE AND SYSTEM OPS CHECKED NORMAL. RETURNED AIRSDR 97ZZZX3371Fire Detector · malfunctionedMIA - AFTER TAKEOFF - RECEIVED FIRE WARNING ON NR 2 ENGINE. SHUT DOWN ENGINE AND FIRE WARNING CEASED. RETURNED TO MIA AND LANDED WITHOUT INCIDENT. INSPECTION REVEALED DEFECTIVE FIRE WARNING ELEMENT ON RIGHT AFT COWLING DOOR. REPLACED ELEMENT AND SYSTEM CHESDR 96ZZZX5871Spar · crackedDURING C-CHECK INSPECTION, FOUND NR 1 PYLON UPPER OUTBOARD SPAR CRACKED. REMOVED AND REPLACED NR 1 PYLON UPPER OUTBOARD SPAR IAW DOUGLAS DRAWING 5895081. (X)SDR 96ZZZX5627Spar · crackedDURING C-CHECK INSPECTION, FOUND NR 1 PYLON UPPER OUTBOARD SPAR CRACKED. REMOVED AND REPLACED NR 1 PYLON UPPER OTBD SPAR IAW DOUGLAS DRAWING 5895081.SDR 95ZZZM405Skin · crackedDURING B-CHECK, MAINTENANCE FOUND A .5 INCH CRACK ON LEFT WING UPPER SURFACE SKIN AT STATION 90.0. CUT OUT CRACK SECTION, INSTALLED 1.5 INCH FILLER AND 10 INCH BY 8 INCH EXTERNAL DOUBLER IAW SRM 57-2-1, FIG 20.SDR 95ZZZM404Skin · crackedDURING B-CHECK, MAINTENANCE FOUND A 1.5 INCH CRACK ON RIGHT WING UPPER SURFACE SKIN AT STATION 75.312. CUT OUT CRACK SECTION, INSTALLED TWO .75 INCH FILLER AND 2 FOOT BY 1 FOOT EXTERNAL DOUBLER IAW SRM 57-2-1, FIG 39.SDR 95ZZZM94Sensor · detachedON DEPARTURE MIAMI EXPERIENCED FIRE WARNING ON NR 2 ENGINE. SHUTDOWN ENGINE AND RETURNED AND LANDED WITHOUT INCIDENT. INSPECTION REVEALED DETACHED FIRE WARNING SENSOR ON AFT COWL. PERFORMED OVERWEIGHT LANDING INSPECTION AND REPLACED FIRE WARNING SENSOR. AIR
Back to N57FB, cancelled Nov 4, 2013