N1381A
Service difficulty reports · 382
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 = 'N1381A' 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 = 'N1381A' 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 UIEA2018010800028Fitting · leakingRIGHT IDG LEAKING AT SERVICE DRAIN FITTING. REMOVED AND REPLACED THE IDG SERVICE DRAIN FITTING IAW AMM 24-11-00, NO LEAKS NOTED.SDR UIEA2018010200001Valve · malfunctionedRIGHT ENGINE PRV SATUS MESSAGE. OPS THE RT ENGINE PRV MANUALLY SEVERAL TIMES, CHECKED PRVC SOLENOID, OPS OK, AND CHECKED MUSCLE AIR LINE INTEGRITY, NO LEAKS NOTED. VALVE OPERATED NORMALLY WITH REVERSE FLOW. RAN THE RT ENGINE AS REQUIRED, PRV OPERATED NSDR UIEA2017120302343Fire Detector · malfunctionedMAIN CARGO FIRE MASTER WARNING INDICATION DURING PRE-FLIGHT W/MAIN CARGO LOOP 2 STATUS MESSAGE. TROUBLESHOT IAW WDM 26-16-31, AND SSM 26-16-03. FOUND A BAD DETECTOR AT POSITION 2C2E. REMOVED AND REPLACED THE DETECTOR IAW AMM 26-14-01. OPS CHECKED GOOD IAW AMSDR UIEA2017112702296Circuit Card · malfunctionedMAIN CARGO FIRE INDICATION DURING PRE-FLIGHT. PERFORMED A FIRE LOOP TEST IAW AMM 26-11-01, NO FAULTS NOTED, OK FOR SERVICE. REMOVED AND REPLACED THE MAIN CARGO BAY CIRCUIT CARD M20206 IAW AMM 26-10-01. SYSTEM OPS CHECKED GOOD AT THIS TIME.SDR UIEA2017112302282Smoke Detector · inoperativeMAIN CARGO SMOKE DETECTOR 1C & 2E LOOP 2 INOP. TRANSFERRED TO MDDR 86255 AS PER MEL 26-16-02-01 CAT C.SDR UIEA2017112002263Exciter · malfunctionedLEFT ENGINE REQUIRED 2 START ATTEMPTS. SECOND START SUCCESSFUL. NO PARAMETERS EXCEEDED. REMOVED AND INSTALLED A NR 1 IGNITION EXCITER BOX ON THE LEFT ENGINE IAW AMM 74-11-01. PERFORMED AUDIBLE TEST AND TEST OK. OPERATIONAL CHECK GOOD AT THIS TIME PER AMM 80-11SDR UIEA2017112002262Warning Light · false activationSTATUS MESSAGE FOR THE MAIN CARGO FIRE LOOP NR 2 INTERMITTENTLY DISPLAYED DURING CRUISE. PERFORMED A FIRE/OVERHEAT TEST. OPS CHECKED NORMAL IAW AMM 26-10-00, NO DEFECTS NOTED.SDR UIEA2017112102278Warning Message · false activationMAIN CARGO FIRE LOOP NR 2 STATUS MESSAGE. PERFORMED A FIRE LOOP TEST IAW AMM 26-11-01, NO DEFECTS NOTED. OK FOR SERVICE.SDR UIEA2018021100200Controller · malfunctionedCREW REPORT L2 WINDOWN HEAT EICAS WAS INTERMITTENT. MESSAGE WOULD CLEAR WITH CREW PROCEDURE. R & R& THE L2 & R1 WINDOWN HEAT CONTROLLER IAW AMM 30-41-01. OPS CHECKED GOOD.SDR UIEA2017101901980Adc · failedDURING CLIMB THRU FL 180, LT ADC FAILED. REMOVED AND REPLACEDTHE LT ADC COMPUTER IAW AMM 34-12-01. OPS CHECKED NORMAL, PITOT STATIC LEAK CHECKED ACCOMPLISHED IAW AMM 34-11-00, NO DEFECTS NOTED. REMOVED AND REPLACED RT ADC COMPUTER IAW AMM 34-12-01, OPS CHESDR UIEA2017073101389Rivet · shearedNR 1 ENGINE LT CORE COWL INTERIOR SURFACE UPPER AFT EDGE WEAR STRIP ATTACH RIVETS FOUND SHEARED. NR 1 ENGINE LT CORE COWL INTERIOR SURFACE UPPER AFT EDGE WEAR STRIP ATTACH SHEARED RIVETS REMOVED AND REPLACED AS PER SRM 51-40-02 REV 104.SDR UIEA2017080101407Rivet · shearedNR 1 ENGINE LT CORE COWL INTERIOR SURFACE UPPER DATA PLATE SUPPORT ATTACH RIVETS FOUND SHEARED. NR 1 ENGINE LT CORE COWL INTERIOR SURFACE UPPER DATA PLATE SUPPORT ATTACH SHEARED RIVETS REMOVED AND REPLACED AS PER SRM 51-40-02 REV 104.SDR UIEA2017080101408Fastener · damagedNR 2 ENGINE RT CORE COWL FWD HINGE ATTACH FASTENER FOUND DAMAGED AS MARKED. NR 2 ENGINE RT CORE COWL FWD HINGE ATTACH DAMAGED FASTENER REMOVED AND REPLACED AS PER SRM 51-40-02 REV 104.SDR UIEA2017080301412Rivet · shearedNR 2 ENGINE RT CORE COWL INTERIOR SURFACE UPPER DATA PLATE SUPPORT ATTACH RIVETS FOUND SHEARED. NR 2 ENGINE RT CORE COWL INTERIOR SURFACE UPPER DATA PLATE SUPPORT ATTACH SHEARED RIVETS REMOVED AND REPLACED AS PER SRM 51-40-02 REV 104.SDR UIEA2017081101457Doubler · wornNR 2 ENGINE LT CORE COWL ZEE FRAME FOUND EXISTING REPAIR DOUBLER WORN, LOCATED 2ND FROM FWD. NR 2 ENGINE LT CORE COWL ZEE& FRAME LOCATED 2ND FROM FWD EXISTING WORN REPAIR FILLER AND DOUBLER REMOVED AND NEW FILLER AND DOUBLER FABRICATED AND INSTALLED AS PER SRMSDR UIEA2017081101458Frame · wornNR 1 ENGINE RT CORE COWL ZEE FRAME FOUND WORN LOCATED 5TH FROM FWD LOWER SECTION ADJACENT TO SUPPORT PLATE. NR 1 ENGINE RT CORE COWL ZEE FRAME LOCATED 5TH FROM FWD WORN AREA PATCH REPAIR CARRIED OUT AS PER SRM 54-42-02-2R-2 REPAIR 2 REV 104.SDR UIEA2017081101460Seal · damagedNR 1 ENGINE LT CORE COWL FAIRING UPPER EDGE FLIPPER DOOR SEAL FOUND DAMAGED. NR 1 ENGINE LT CORE COWL FAIRING UPPER EDGE FLIPPER DOOR DAMAGED SEAL REMOVED AND REPLACED AS PER SRM 51-40-02 REV 104.SDR UIEA2017081101461Seal · damagedNR 1 ENGINE RT CORE COWL FAIRING UPPER EDGE FLIPPER DOOR SEAL FOUND DAMAGED. NR 1 ENGINE RT CORE COWL FAIRING UPPER EDGE FLIPPER DOOR DAMAGED SEAL REMOVED AND REPLACED AS PER SRM 51-40-02 REV 104.SDR UIEA2017081101462Seal · damagedNR 2 ENGINE LT CORE COWL FAIRING UPPER EDGE FLIPPER DOOR SEAL FOUND DAMAGED. NR 2 ENGINE LT CORE COWL FAIRING UPPER EDGE FLIPPER DOOR DAMAGED SEAL REMOVED AND REPLACED AS PER SRM 51-40-02 REV 104.SDR UIEA2017081101463Seal · damagedNR 2 ENGINE RT CORE COWL FAIRING UPPER EDGE FLIPPER DOOR SEAL FOUND DAMAGED. NR 2 ENGINE RT CORE COWL FAIRING UPPER EDGE FLIPPER DOOR DAMAGED SEAL REMOVED AND REPLACED AS PER SRM 51-40-02 REV 104.SDR UIEA2017081101464Rivet · shearedNR 1 ENGINE NOSE COWL EXTERIOR SURFACE AFT EDGE RUB STRIP ATTACH RIVETS FOUND SHEARED LOCATED 10 TO 11 O'CLOCK POSITION. NR 1 ENGINE NOSE COWL EXTERIOR SURFACE AFT EDGE RUB STRIP ATTACH SHEARED RIVETS REMOVED AND REPLACED AS PER SRM 51-40-02 REV 104.SDR UIEA2017081501484Skin · damagedAFT UPPER FUSELAGE AT APPROXIMATELY BS 1432, BETWEEN STRINGERS 18R TO 19R, FOUND WITH PREVIOUSLY BLEND OUT. AREA REPAIRED IAW SRM 53-00-01-2R-6, REPAIR 6, FIGURE 201, REV 104. REPAIR CLASSIFIED AS MAJOR.SDR UIEA2017081701493Rub Strip · crackedNR 2 NACELLE EXTERIOR SURFACE, FWD UPPER WEAR STRIPS FOUND CRACKED. THE WEAR STRIPS WERE REMOVED AND REPLACED IAW SRM 51-40-02, REV 29.SDR UIEA2017081701494Support · crackedNR 2 NACELLE INTERIOR SURFACE FWD SUPPORT FOUND CRACKED LOCATED IN THE UPPER SECTION. THE SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-40-02, REV 29.SDR UIEA2017082101516Skin · wornNR 2 NACELLE FAIRING SKIN INTERIOR SURFACE UPPER AFT CUTOUT SECTION FOUND WORN. THE FAIRING SKIN WAS REPAIRED IAW SRM 54-42-01-2R-5, REPAIR 5, REV 29.SDR UIEA2017082101517Skin · wornNR 1 NACELLE FAIRING SKIN FOUND WORN. THE FAIRING SKIN WAS REPAIRED IAW SRM 54-42-01-2R-5, REPAIR 5, REV 29.SDR UIEA2017082101518Skin · wornNR 1 NACELLE FAIRING SKIN INTERIOR SURFACE UPPER AFT CUTOUT SECTION FOUND WORN. THE FAIRING SKIN WAS REPAIRED IAW SRM 54-42-01-2R-5, REPAIR 5, REV 29.SDR UIEA2017082101519Skin · wornNR 2 NACELLE FAIRING SKIN INTERIOR SURFACE UPPER AFT CUTOUT SECTION FOUND WORN. THE FAIRING SKIN WAS REPAIRED IAW SRM 54-42-01-2R-5, REPAIR 5, REV 29.SDR UIEA2017082301527Seal · damagedNR 1 NACELLE FAIRING UPPER EDGE FWD STRIP SEAL FOUND DAMAGED. THE SEAL WAS REMOVED AND REPLACED IAW SRM 51-40-02, REV 29.SDR UIEA2017082301528Seal · damagedNR 1 NACELLE FAIRING UPPER EDGE AFT STRIP SEAL FOUND DAMAGED. THE SEAL WAS REMOVED AND REPLACED IAW SRM 51-40-02, REV 29.SDR UIEA2017082301529Stop · missingNR 1 NACELLE FAIRING UPPER EDGE FLIPPER DOOR AFT STOP FOUND MISSING. A NEW STOP WAS INSTALLED IAW SRM 51-40-02, REV 29.SDR UIEA2017082401534Skin · scratchedNR 1 NACELLE SKIN SCRATCHED. REPAIRED IAW SRM 54-42-01-2R-7, REPAIR 7, REV 29.SDR UIEA2017082401539Rub Strip · wornNR 1 NACELLE FAIRING INTERIOR SURFACE AFT UPPER EDGE RUB STRIP FOUND WORN. THE RUB STRIP WAS REMOVED AND REPLACED IAW SRM 51-40-02, REV 29.SDR UIEA2017082401540Rub Strip · wornNR 1 NACELLE FAIRING INTERIOR SURFACE AFT UPPER EDGE RUB STRIP FOUND WORN. THE RUB STRIP WAS REMOVED AND REPLACED IAW SRM 51-40-02, REV 29.SDR UIEA2017082401541Rub Strip · wornNR 2 NACELLE FAIRING INTERIOR SURFACE AFT UPPER EDGE RUB STRIP FOUND WORN. THE RUB STRIP WAS REMOVED AND REPLACED IAW SRM 51-40-02, REV 29.SDR UIEA2017082701556Screw · damagedNR 1 NACELLE NOSE COWL HOIST POINT SCREWS FOUND DAMAGED. THE SCREWS WERE REMOVED AND REPLACED IAW AMM 20-11-00, REV 122.SDR UIEA2017082701557Screw · damagedNR 2 NACELLE NOSE COWL HOIST POINT SCREWS FOUND DAMAGED. THE SCREWS WERE REMOVED AND REPLACED IAW AMM 20-11-00, REV 122.SDR UIEA2017082801564Channel · wornNR 2 NACELLE HAT CHANNEL ATTACH STOP FOUND WORN. THE HAT CHANNEL WAS REMOVED AND REPLACED IAW SRM 51-40-02, REV 29.SDR UIEA2017082801565Bracket · wornNR 2 NACELLE DOOR HOLD OPEN ROD STOW PIN ADAPTER AND BRACKET FOUND WORN. THE STOW PIN SUPPORT ADAPTER AND BRACKETS WERE REMOVED AND REPLACED IAW SRM 51-40-02, REV 29.SDR UIEA2017082801566Bracket · wornNR 2 NACELLE DOOR HOLD OPEN ROD STOW PIN ADAPTER AND BRACKET FOUND WORN. THE STOW PIN SUPPORT ADAPTER AND BRACKET WERE REMOVED AND REPLACED IAW SRM 51-40-02, REV 29.SDR UIEA2017083001584Seal · tornNR 2 NACELLE FWD SEAL FOUND TORN. THE SEAL WAS REMOVED AND REPLACED IAW SRM 51-40-02, REV 29.SDR UIEA2017083001585Rub Strip · crackedNR 1 NACELLE RUB STRIP FOUND CRACKED AT THE 9 TO 11 O'CLOCK POSITIONS. THE RUB STRIP WAS REMOVED AND REPLACED IAW SRM 51-40-02, REV 29.SDR UIEA2017090401594Skin · corrodedCORROSION FOUND THE SKIN BS 1197+19, STRINGER 36R. REPAIRED IAW SRM 53-00-01-2R-12, REPAIR 12, DETAIL IV, FIGURE 201.SDR UIEA2017090501603Seal · tornNR 1 NACELLE INTERIOR SURFACE, UPPER FWD SEAL FOUND TORN. THE SEAL WAS REMOVED AND REPLACED IAW SRM 51-40-02, REV 29.SDR UIEA2017090601605Plate · wornNR 2 NACELLE PLATE WORN. THE PLATE WAS REMOVED AND REPLACED IAW SRM 51-40-02, REV 29.SDR UIEA2017090601606Plate · wornNR 1 NACELLE PRESSURE RELIEF DOOR CUT OUT HAD TWO STRIKER PLATES WORN. THE STRIKER PLATES WERE REMOVED AND REPLACED IAW SRM 51-40-02, REV, 29.SDR UIEA2017090601607Stringer · crackedFASTENER HOLE FOUND CRACKED AT BS 1548, ON STRINGER 3L. REPAIRED IAW 1162-17 REV -.SDR UIEA2017090601610Channel · crackedNR 2 NACELLE AFT HAT CHANNEL FOUND CRACKED AND EXISTING REPAIR DOUBLER WORN. THE HAT CHANNEL WAS REMOVED AND REPLACED IAW SRM 51-40-02, REV 29.SDR UIEA2017090701611Skin · scratchedNR 1 NACELLE SKIN FOUND SCRATCHED. THE SCRATCHES WERE REMOVED AND FOUND WITHIN LIMITS IAW SRM 54-42-01-1A-1, FIGURE 101, DETAIL III, REV 29.SDR UIEA2017090701612Skin · scratchedNR 1 SKIN SKIN FOUND SCRATCHED. THE SCRATCHES WERE REMOVED AND FOUND WITHIN LIMITS IAW SRM 54-42-01-1A-1, FIGURE 101, DETAIL III, REV 29.
Back to N1381A