N1373A
Service difficulty reports · 479
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 = 'N1373A' 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 = 'N1373A' 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 UIEA2017102502086Shaft · corrodedLEFT WING POSITION NR 2 SHAFT FOUND CORRODED. THE INPUT SHAFT WAS REPLACED.SDR UIEA2017102502084Ring · corrodedFOUND CORROSION ON REACTION RING SPLINES POSITION 2. THE REACTION RING WAS REPLACED.SDR UIEA2017102502083Contact · brokenRELAY K101 CONTACT BROKEN IN P34(<P>REPLACED GROUND HANDLING RELAY K101 IN P34</P>)SDR UIEA2017102502082Relay · brokenGROUND SERVICE TRANSFER RELAY K102 BROKEN IN P32. REPLACED THE GROUND SERVICE TRANSFER RELAY.SDR UIEA2017102502081Ring · corrodedFOUND CORROSION ON REACTION RING SPLINES POSITION 7. REACTION RING WAS REPLACED.SDR UIEA2017102502080Ring · corrodedFOUND CORROSION ON REACTION RING SPLINES POSITION 1. THE REACTION RING WAS REPLACED.SDR UIEA2017102502079Sensor · brokenLEFT PACK COMPRESSOR OUTLET TEMP SENSOR TA41 BROKEN. REMOVED AND REPLACED THE LEFT PACK COMPRESSOR OUTLET TEMP SENSOR.SDR UIEA2017102502078Control Panel · malfunctionedCABIN PRESSURE SELECTOR CONTROL PANEL INDICATION FLUCTUATED. REMOVED AND REPLACED THE CABIN PRESSURE SELECTOR CONTROL PANEL.SDR UIEA2017102502077Hose · missingAFT CARGO FIRE DETECTION HOSES ARE MISSING AT BS 1197+132. NEW FIRE HOSES WERE INSTALLED.SDR UIEA2017102502095Circuit Card · failedEEC DISCRETE CARD M644 INTERNAL RELAY K13 FAILED TO OPERATE. THE CARD WAS REPLACED.SDR UIEA2017102502096Tube · missingAFT CARGO BS 1502, MISSING SMOKE DETECTION TUBE. A NEW TUBE WAS INSTALLED.SDR UIEA2017102602109Tube · damagedFWD CARGO BAY FIRE EXTINGUISHER TUBE FOUND DAMAGED. REMOVED AND REPLACED THE FIRE EXTINGUISHER TUBE.SDR UIEA2017102602108Blanket · tornAFT CARGO APU PNEUMATIC DUCT AT BS 1600 BLANKETS TORN. REMOVED AND REPLACED THE PNEUMATIC DUCT BLANKETS.SDR UIEA2017102602107Duct · crackedFWD CARGO E/E DUCT FOUND CRACKED. THE DUCT WAS REPAIRED.SDR UIEA2017102602106Sensor · unsecureFUSELAGE A/C BAY LT INLET PACK TEMP SENSOR TS 294 FOUND LOOSE AND ONE SCREW MISSING. THE SENSOR WAS INSTALLED.SDR UIEA2017102602105Seal · tornFWD CARGO LOWER LOB BS 340 DUCT SEAL WAS FOUND TORN. THE SEAL WAS REPLACED.SDR UIEA2017102502099Duct · damagedFWD CARGO, BS 281 - 348, RT COOLING DUCT FOUND SOFT IN THE AFT SIDE. THE COOLING DUCT WAS REPAIRED.SDR UIEA2017102502098Tube · deformedFWD CARGO TWO COOLING TUBES AT BS 390 AND 608 FOUND DEFORMED. NEW COOLING TUBES WERE INSTALLED.SDR UIEA2017102502097Barrel Nut · wornNR 2 PYLON AFT ENGINE MOUNT BARREL NUTS WORN. NEW BARREL NUTS INSTALLED.SDR UIEA2017102602111Hose · missingAFT CARGO FIRE DETECTION HOSE IS MISSING IN BS 1351 - 1379. A NEW FIRE HOSE WAS INSTALLED.SDR UIEA2017102602110Hose · missingAFT CARGO FIRE DETECTION HOSE IS MISSING AT BS 1439. A NEW FIRE HOSE WAS INSTALLED.SDR UIEA2017102602112Duct · damagedAFT CARGO BS 1285 HEATING DUCT IS DAMAGED. A NEW FIRE DUCT WAS INSTALLED.SDR UIEA2017102602113Packing · leakingLEFT AND RIGHT MAIN TANK BOOST PUMP HOUSING FOUND SIGN OF FUEL LEAKAGE FROM CONDUIT. A NEW PACKING WAS INSTALLED.SDR UIEA2017102602114Packing · deterioratedLEFT AND RIGHT JETTISON PUMP HOUSING FOUND SIGN OF FUEL LEAKAGE FROM CONDUIT. NEW PACKING INSTALLED.SDR UIEA2017102602115Drain Line · brokenFWD CARGO AFT WALL MIX BAY DRAIN PIPE BROKEN. THE DRAIN PIPE WAS REPAIRED.SDR UIEA2017102602116Blanket · tornAFT CARGO FWD WALL, BS 1079.20 APU DUCT BLANKETS TORN. REMOVED AND REPLACED THE APU DUCT BLANKETS.SDR UIEA2017102602117Bolt · damagedNR 2 ENGINE PRECOOLER HINGE BOLTS AND BUSHINGS SHAFTED. NEW BOLTS AND BUSHINGS INSTALLED.SDR UIEA2017102602118Hose · deterioratedFWD CARGO, BS 654, ONE A/C COOLING HOSE FOUND DETERIORATED, A NEW HOSE WAS INSTALLED.SDR UIEA2017102602119Seal · tornFWD CARGO BAY , ONE DUCT SEAL FOUND TORN. A NEW SEAL WAS INSTALLED.
Back to N1373A