N12322, cancelled Mar 21, 2013
Service difficulty reports · 103
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 = 'N12322' AND deregistration_id = 'N12322-2013-03-21' 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 = 'N12322' AND deregistration_id = 'N12322-2013-03-21' 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 CALA0800020Beam · corrodedSTA 947 BEAM CORRODED AROUND SCREW HOLES LBL 10 TO RBL 5. REPAIRED PER SRM 53-00-51.SDR CALA0800014Angle · corrodedLEFT Z-ANGLE CORRODED AT STA 947-987. INSTALLED NEW LEFT Z-ANGLE PER SRM 51-40-02.SDR CALA0800010Seat Track · corrodedRIGHT O/B SEAT TRACK CORRODED STA 887 TO 927. FABRICATED AND INSTALLED NEW SEAT TRACK SECTION PER SRM 53-00-02 REPAIR 3.SDR CALA0800008Frame · crackedFUSELAGE FRAME IS CRACKED AT STA 616 BETWEEN S7L AND S8L. REPAIRED PER SRM 53-00-07 FIG 201.SDR CALA0800011Floorbeam · corrodedSTA 986.5 FLOORBEAM CORRODED RBL 22 TO LBL 9. REMOVED AND REPLACED UPPER T-CHORD PER SRM 51-40-02.SDR CALA0800005Door Frame · crackedFWD ENTRY FRAME STA 310 L ABOVE L-1 DOOR CUTOUT CRACKED. REMOVED DAMAGED AREA, FABRICATED AND INSTALLED REPAIR DOUBLER PER SRM 51-70-11 FIG 1.SDR CALA0800004Stringer Clip · crackedCLIP CRACKED AT STA 616, S6L. REMOVED AND REPLACED STRINGER CLIP PER SRM 51-40-02.SDR CALA0800003Stringer Clip · crackedCLIP CRACKED AT STA 597, S8L. REMOVED AND REPLACED STRINGER CLIP PER SRM 51-40-02.SDR CALA0800002Stringer Clip · crackedCLIP CRACKED AT STA 578, S8L. REMOVED AND REPLACED STRINGER CLIP PER SRM 51-40-02.SDR CALA0600107Stringer · corrodedINSPECTION FOUND STRINGER 27R CORRODED JUST AFT OF STA 500D. THE CORRODED SECTION OF STRINGER WAS REMOVED AND REPAIR PARTS WERE INSTALLED IAW SRM 53-30-03.SDR CALA0600116Shear Tie · corrodedINSPECTION FOUND SHEAR TIE CORRODED AT STA 500 BETWEEN S26R AND S27R, RBL 8 TO RBL 16. A NEW SHEAR TIE WAS INSTALLED IAW SRM 53-00-07, FIGURE 201.SDR CALA0400017Stringer · corrodedINSPECTION FOUND STRINGER 25L CORRODED AFT OF STA 967. A REPAIR WAS INSTALLED IAW SRM 53-60-03 AND 53-00-03.SDR CALA0400001Skin · canningC2 DOOR LOWER SKIN OIL CANNED LOWER AFT. CUT OUT DAMAGED SECTION OF SKIN. FABRICATED AND INSTALLED REPAIR DOUBLER PER SRM 52-00-01.SDR CALA0400102Floorbeam · corrodedINSPECTION FOUND CORROSION ALONG THE UPPER SURFACE OF THE UPPER SECTION OF THE STA 967 FLOORBEAM. THE CORRODED UPPER SECTION WAS TRIMMED OUT AND A NEW REPAIR SECTION WAS INSTALLED IAW ECRA 5311-01142.SDR CALA0300727Floor Panel · crackedREMOVED AFT LAV WEBS TO FACILITATE REPAIR OF APB. REMOVED AND REPLACED WEBS PER SRM 51-10-02. CRACKED 2 X 5 INCH.SDR CALA0300724Floor Support · corrodedINSPECTION FOUND FLOOR SUPPORTS CORRODED AT STA 772, RBL 3 AND RBL 7. REPAIRED FLOOR SUPPORTS IAW ECRA 5320-01603.SDR CALA0300723Bulkhead · corrodedINSPECTION FOUND CORROSION ON APB WEB FORWARD FACE IB OF S27L ALONG LOWER RIVET ROW AT STA 1016. THE CORRODED SECTION OF WEB WAS CUT OUT AND A REPAIR DOUBLER WAS INSTALLED IAW SRM 53-80-08 AND MFG DRAWING NR 65C28106-1.SDR CALA0300722Keelbeam · corrodedINSPECTION FOUND KEEL BEAM LT LOWER CHORD CORRODED FROM STA 699-727. REPAIRED IAW ECRA 5310-03740.SDR CALA0300721Fitting · corrodedINSPECTION FOUND NR 2 ENGINE PYLON OB CROSSBEAM MOUNT FITTING CORRODED. THE FITTING WAS REPAIRED IAW ECRA 5440-01235.SDR CALA0300715Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986, RBL 18-42. THE CORROSION WAS REMOVED AND A STRAP WAS INSTALLED IAW SRM 53-00-51.SDR CALA0300321Floorbeam · corrodedINSPECTION FOUND UPPER SECTION OF FLOORBEAM CORRODED AT BS 328. THE FLOORBEAM WAS REPAIRED IAW ECRA 5321-01145.SDR CALA0300320Floorbeam · corrodedINSPECTION FOUND CORROSION ALONG THE FLOORBEAM AT STA 294.5, RBL 31.5. THE FLOORBEAM WAS REPAIRED IAW ECRA 5321-01147.SDR CALA0300319Skin · gougedINSPECTION FOUND A GOUGE IN FUSELAGE SKIN AT THE FORWARD LOWER CORNER OF THE L2 DOOR, STA 965, S17L. THE GOUGE MEASURED 2 X 1.4 INCH THE AREA WAS REPAIRED IAW ECRA 5330-03257. A DIP WAS ISSUED TO ACCOMPLISH AN HFEC INSPECTION AND GV INSPECTION AT A THRESHOLDSDR CALA0300278Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 1006 FROM LBL 24 TO LBL 28. THE CORRODED SECTION OF FLOORBEAM WAS REPLACED IAW ECRA 5310-03851.SDR CALA0300274Floorbeam · corrodedINSPECTION FOUND UPPER SURFACE OF FLOORBEAM CORRODED AT STA 312, RBL 38 TO LBL 20. THE FLOORBEAM WAS REPAIRED IAW SRM 53-10-51.SDR CALA0300273Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED ON TOP SIDE IN TWO PLACES AT STA 986, RBL 15-44. REPLACED T-CAP IAW ECRA 5310-03851.SDR CALA0300272Floorbeam · corrodedINSPECTION FOUND FLOORBEAM T-CAP CORRODED ON TOP SIDE AND BOTTOM SIDE AT FS 986.5, LBL 25. THE FLOORBEAM WAS REPAIRED BY SPLICING IN A NEW SECTION IAW ECRA 5310-03851.SDR CALA0300271Pressure Panel · crackedINSPECTION FOUND A 2 INCH CRACK IN PRESSURE DECK WEB AT STA 663.75 IN RT WHEEL WELL JUST O/B OF J-BOX. THE CRACKED AREA WAS REMOVED AND A REPAIR WAS INSTALLED IAW SRM 53-60-51, PAGE 214-221.SDR CALA0300317Pressure Panel · crackedINSPECTION FOUND CRACKS IN PRESSURE DECK WEB AT STA 665 TO 675, RBL 35 TO 45. A WEB STIFFENER WAS INSTALLED IAW ECRA 5312-01022.SDR CALA0300318Sill · corrodedINSPECTION FOUND THE L-1 DOOR LOWER SILL CORRODED AT BS 314, LBL 57. THE DOOR SILL WAS REPAIRED IAW ECRA 5312-01146.SDR CALA0200194Stringer · corrodedINSPECTION FOUND STRINGER 26L CORRODED IN AFT BAGGAGE BIN AT BS 727D-827. THE CORRODED SECTION OF STRINGER WAS REMOVED AND REPAIR SPLICES WERE INSTALLED IAW ECRA 5311-01119.SDR CALA0200181Cargo Track · corrodedINSPECTION FOUND AFT BAGGAGE BIN LT TIE DOWN TRACK CORRODED AT STA 727C-947. THE CORRODED SECTION OF TRACK WAS REMOVED AND A NEW SECTION WAS INSTALLED IAW SRM 53-00-53, FIGURE 202.SDR CALA0200178Cargo Track · crackedINSPECTION FOUND A 4 INCH CRACK AT ATTACH POINT OF RIGHT TIE DOWN TRACK, STA 747. A NEW SECTION OF TIE DOWN TRACK WAS SPLICED.SDR CALA0200164Stringer · corrodedINSPECTION FOUND STRINGER 26R CORRODED BETWEEN STA 1006 AND 1016 IN AFT EQUIPMENT BAY. THE STRINGER WAS REMOVED AND REPLACED IAW SRM 51-10-02.SDR CALA0000624Oven · smokeAFT GALLEY OVEN STARTED SMOKING. FLIGHT ATTENDANT PULLED CIRCUIT BREAKER. NO EVIDENCE OF FIRE. MAINTENANCE INSPECTED OVEN SYSTEM AND COULD NOT DUPLICATE THE PROBLEM.SDR CALA9901648Charger · inoperativeINSPECTION FOUND FORWARD GALLEY SERVICE DOOR SLIDE LIGHT ASSEMBLY INOPERATIVE. MAINTENANCE FOUND CHARGER ASSEMBLY INOPERATIVE. THE CHARGER ASSEMBLY WAS REPLACED AND OPERATIONAL CHECKS WERE GOOD.SDR CALA9901557Web · crackedINSPECTION FOUND A 2 CRACK IN WEB BELOW R-2 DOOR ASSIST HANDLE AT STA 950, S11R AND A 2 CRACK WAS FOUND IN WEB BELOW L-2 DOOR ASSIST HANDLE AT STA 950, S11L. A DOUBLER WAS INSTALLED AT EACH LOCATION IAW SRM 51-70-13.SDR CALA9901556Floorbeam · corrodedINSPECTION FOUND CABIN FLOORBEAM CORRODED AT BS 312 FROM RBL 36 TO LBL 18. THE CORRODED SECTION OF FLOORBEAM WAS REPLACED IAW SRM 53-10-51.SDR CALA9901554Stringer · crackedINSPECTION FOUND A 1 CRACK IN STRINGER 16R AT STA 500C. THE STRINGER SECTION WAS REPLACED IAW SRM 53-00-03, FIGURE 201.SDR CALA9901549Skin · wornINSPECTION FOUND FUSELAGE CROWN SKIN WORN BY DORSAL FIN AT STA 867-907. THE WORN AREA WAS REMOVED AND A SKIN REPAIR WAS INSTALLED IAW SRM 53-00-01.SDR CALA9901548Skin · dentedINSPECTION FOUND C-1 DOOR EXTERNAL SKIN DENTED. THE DENTED AREAS WERE CUT OUT AND REPAIR DOUBLERS WERE INSTALLED IAW SRM 52-00-01, FIGURE 203.SDR CALA9901540Seat Track · corrodedINSPECTION FOUND CABIN SEAT TRACK CORRODED AT STA 328-344, RBL 42. THE SEAT TRACK WAS REPLACED IAW SRM 53-00-52, FIGURE 202 AND 51-40-02.SDR CALA9901539Floorbeam · corrodedINSPECTION FOUND CABIN FLOORBEAM CORRODED AT STA 344 FROM RBL 18 TO LBL 48. A NEW FLOORBEAM UPPER CHORD WAS INSTALLED IAW SRM 53-10-51, FIGURE 205.SDR CALA9901537Floorbeam · corrodedINSPECTION FOUND RT AND LT AFT LAV FLOORBEAMS CORRODED AT STA 1016, RBL 6.5 AND LBL 28. THE FLOORBEAM UPPER CHORD SECTIONS WERE REPLACED IAW ECRA 5310-03851.SDR CALA9901535Floorbeam · corrodedINSPECTION FOUND CABIN FLOORBEAM CORRODED AT STA 294.5, RBL 54 TO LBL 24. THE FLOORBEAM WAS REPAIRED IAW SRM 53-10-51, FIGURE 205.SDR CALA9901558Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CAP IN AFT LEFT LAV AREA CORRODED AT STA 986. REPAIRED IAW ECRA 5310-03851.SDR CALA9901538Skin · crackedINSPECTION FOUND A 1 INCH CRACK IN CAPTAIN'S L-1 WINDOW FRAME SKIN. A REPAIR DOUBLER WAS INSTALLED IAW ECRA 5330-02833.SDR CALA9800142Trans Cylinder · inoperativeWHEN GEAR HANDLE WAS SELECTED DOWN ON APPROACH, THE GEAR DID NOT EXTEND ON INITIAL ATTEMPT. THE GEAR WAS CYCLED AND EXTENDED NORMALLY. THE AIRCRAFT LANDED WITHOUT INCIDENT. THE NLG TRANSFER CYLINDER AND NLG MODULAR PACKAGE WERE REMOVED AND REPLACED IAW MM 32SDR CALA9701596Skin · crackedINSPECTION FOUND TWO 1/2 CRACK IN #2 PYLON SKIN ON OUTBOARD SIDE AT PANEL #5824 CUTOUT. THE CRACKS WERE STOP DRILLED. A DOUBLER WAS FABRICATED AND INSTALLED IAW ECRA 5430-01204.SDR CALA9600988Oil Line · leakingTHE NR 1 ENGINE OIL QUANTITY DROPPED TO ZERO AND THE OIL PRESSURE BEGAN TO DROP AFTER TAKEOFF FROM CLE. THE AIRCRAFT WAS RETURNED TO CLE WHERE IT LANDED WITHOUT INCIDENT. MAINTENANCE FOUND THE LINE TO FUEL/OIL COOLER LOOSE AND LEAKING. THE LINE WAS TIGHTENE
Back to N12322, cancelled Mar 21, 2013