N18223
Service difficulty reports · 119
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 = 'N18223' 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 = 'N18223' 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 CALA2021101801891Fitting · crackedB737-57-4-1262 SHEAR FITTING AT STATION 540 ABD LBL 15.04 IS CRA CKED. REMOVED AND REPLACED SHEAR FITTING AT STATION 540 AND LBL 15.04 IAW B737-800 SRM 51-40-02 AND BAC DWG 111A2000 REV ORIGINAL DATA TRANSCRIBED FROM NSA EMX NR 00104 AND HANGAR NR 5867186 ACCOSDR CALA2021101801890Fitting · crackedB737-57-4-1262 SHEAR FITTING AT STATION 540 AND RBL 40.87 IS CRA CKED. REMOVED AND REPLCED SHEAR FITTING AT STA 540 AND RBL 40.87 IAW B 737-800 SRM 51-40-02 AND BAC DWG 111A2000 REV ORIGINAL DATA TRAN SCRIBED FROM NSA EMX NR 00111 AND HANGAR NR 5867193 ACCOMPLSDR CALA2021101801889Fitting · corrodedB737-57-4-1262 SHEAR FITTING AT STATION 540 AND LBL 6.14 IS CRAC KED. REMOVED AND REPLACED SHEAR FITTING AT STA 540 AND LBL 6.14 IAW B 737-800 SRM 51-40-02 AND BAC DWG 111A20000 REV ORIGINAL CIR C/W DATA WAS TRANSCRIBED FROM NSA EMX NR 00103 AND HANGAR NE 5867SDR CALA2021101801888Fitting · crackedB737-57-04-1262 SHEAR FITTING AT STATON 540 AND RBL 32.40 IS CRA CKED. REMOVED AND REPLACED SHEAR FITTING AT STA 540 AND RBL 32.40 IAW B737-800 SRM 51-40-02 AND BAC DWG 111A2000 REV ORIGINAL CIR C/W DATA WAS TRANSCRIBED FROM HANGAR NR 5867192 NSA EMX NR 00110 SDR CALA2021080901310Indication Sys · unreliableALTITUDE UNRELIABLE F/O AIRSPEED UNRELIABLE F/O EEC ALT NO1 AND NO2 SPEED TRIM FAIL CREW INDICATED UPON TAKEOFF ROT LARGE BIRD NEAR MISS OR POSSIBLE STRIKE ON F/O SIDE. ASCENDED TO 37K, STRABILIZED AT 35K AND REPORTED DESCREPENCY IN LOG BEGAN. FOLLOWED PROCEDSDR CALA2021060700797Switch · intermittentAFT EMERGENCY LIGHT SWITCH AT FLIGHT ATTENDANTS PANEL INTERMITTANT R&R AFT FLIGHT ATTENDANTS EMERGENCY EXIT / LIGHTING/ WORK LIGHT SW PANEL PER AMM 25-25-11, OPS CK''S GOOD ROTABLE PARTS CHANGE WAS INDICATED - TT # 1964165 SN OFF 0346 IPC REFERENCE # 33-26-01SDR CALA2021060700796Housing · damagedEMERGENCY AISLE LIGHT ASSY ON BULL NOSE AT SEAT ROW 30 ABC BROKEN R&R EMERGENCY AISLE LIGHT ASSY AT SEAT ROW 30 ABC BULL NOSE PER AMM 33-51-03, OPS CK GOOD VERIFIED IDT REQUIREMENTSSDR CALA2019090901519Fan · faultyBURNING ODOR REPORTED BY F/AS IN AFT GALLEY WHILE AT THE GATE PLACE ON MEL RIGHT FAN OPERATES NORMALLY - TOMC APPROVED PLACED ON MEL ACCOMPLISHED INSPECTION REF AMM TASK 05-51-26-800-801C1, FOUND LT RECIRCULATION FAN CKT BREAKER OPEN. RESET BREAKER BUT IT OPENSDR CALA2019063001102Warning Message · illuminatedIAS DISAGREE MESSAGE SHOWS ON AIRPSEED DISPLAY FIRST OFFICER''S A/S DISAGREE ILLVM FL370 F/O A/S UNRELIABLE WENT TO OVERSPEED TH EN DROPPED TO 45 IN DESC. PER FIM TASK 31-62-810-876, PERFORMED INITIAL EVALUATION, ADIRS FIM TASK 34-21-00, NO OTHER FAULTS NOTEDSDR CALA2019060700902Warning Light · false activationAUTO BRAKE DISARM LIGHT WILL NOT ARM. PERFORMED FIM TASK 27-62-00-810-830 SPEED BRAKE SYS, OPS CK NORMAL. NO FAULTS FOUND.SDR CALA2018021600620Warning Light · false activationEEC LIGHT ON DURING LANDING. NO THROTTLE RESPONSE DURING TAXI. FOUND EEC LIGHTS EXTINGUISHED ON ARRIVAL. ACCOMPLISHED EEC BITE IAW FIM 73-00, TASK 801 WITH NO FAULTS FOUND, NO HISTORY IN PAST 30 DAYS. OK FOR SERVICE.SDR CALA2018012600328Ballast · faultyBOTH LEFT EMERGENCY EXIT DOOR LIGHTS INOPERATIVE. REMOVED AND REPLACED THE BALLASTS. OPS CHECKED GOOD.SDR CALA2017092203261Clamp · brokenNR 1 ENGINE OIL QTY WENT TO ZERO INFLIGHT. ABOUT 10 MINUTES LATER, THE OIL PRESSURE DECREASED. SHUTDOWN THE ENGINE. EMERGENCY DECLARED. FOUND THE NR 1 ENGINE STARTER BAND CLAMP BROKEN. STARTER MOVED AWAY FROM GEARBOX AND LOST THE OIL. CREW STATED ENGINE SDR CALA2017090102999Lens · detachedCABIN AISLE EMERGENCY EXIT SIGN COVER BY BULKHEAD FELL OFF. INSTALLED LENSSDR CALA2017010900053Battery Pack · dischargedEMERGENCY EXIT ROW INTERIOR LOWER LIGHTS NOT WORKING. REMOVED AND REPLACED BATTERY PACK IN THE RT CARPET SIDE WALL CARPET RISER AREA IAW MM 33-51-06. OPS CK GOOD.SDR CALA2016111400915Battery · dischargedEMERGENCY FLASHLIGHT AFT RT POSITION LED INDICATOR LIGHT NOT FLASHING. R&R AFT RT EMERGENCY FLASHLIGHT BATTERY, LED INDICATOR OK, FLASHLIGHT WORKING OK.SDR CALA2016111400888Battery Pack · unserviceableEMERGENCY EXIT LIGHT BATTERY PACK AT STA 952 LT IS BAD AND NEEDS TO BE REPLACED. REMOVED OLD AND INSTALLED SERVICEABLE BATTERY PACK AT STA 952 LT IAW AMM 33-51-06. OP CHK GOOD.SDR CALA2016111400887Battery Pack · dischargedBATTERY PACK AT STA 952 RT IS BAD AND NEEDS TO BE REPLACED. REMOVED OLD BATTERY PACK AND INSTALLED SERVICEABLE BATTERY PACK AT STA 952 RT IAW AMM 33-51-06. OP CHK GOOD.SDR CALA2016111400886Battery Pack · dischargedEMERGENCY EXIT LIGHT BATTERY PACK AT STA 675 RT SIDE IS BAD. REMOVED AND INSTALLED AIR GRILL AT STA 675 RT SIDE IAW A MM 21-23-03. REMOVED OLD AND INSTALLED SERVICEABLE BATTERY PACK AT STA 675 RT OP CHK GOOD IAW AMM 33-51-06SDR CALA2016010400023Slide · unsecureDOOR 1R SLIDE IS NOT SECURED PROPERLY. REPOSITIONED GIRT DOOR 1R SLIDE SECURED OK AMM 25-66-01-400-804, CHECK OK, ARMS OK, STOWS OK AMM 25-66-01-400-801.SDR CALA2015110200890Skin · corrodedAFT FUSELAGE SKIN HAS CORROSION AROUND LAVATORY. VACUUM WASTE TUBE PORT, STATION 916, BETWEEN STRINGER 21L & 22L. ACCOMPLISHED INTERIM REPAIR IAW ECRA 5331-02057 PT 1. DIP ISSUED, IAW ECRA 5331-02057 PT 1 STEP 13, TO ACCOMPLISH INSPECTION REQUIREMENTS. ON SDR CALA2015030900154Seat Track · crackedAT STATION 727B, RBL 24.75 INBD FLANGE 2ND HOLE FWD HAS CRACK. ACCOMPLISHED REPAIR IAW ECRA 5320-02424 REV ORIGINAL.SDR CALA2015030900153Seat Track · crackedAT STATION 727B, RBL 45.50 INBD AFT FASTENER HOLE CRACKED. ACCOMPLISHED REPAIR IAW ECRA 5320-02424 REV ORIGINAL.SDR CALA2014031000311Frame · crackedCABIN FRAME AT STATION 440RT IS CRACKED AT SUPPORT FITTING BETWEEN STRINGER 8 & STRINGER 9RT IAW LOG PAGE 9603011. INSTALLED REPAIR ANGLES A & B AT STATION 440R IAW EA 5310-04716 REV E OP 2, IAW LP 9603011.SDR CALA2014030700295Stringer · wornUPPER FUSELAGE CROWN STRINGER 15L, STATION 500G TO STATION 500H WORN AT A/C RISE DUCT. REPAIRED STRINGER 15L, STATION 500G TO STATION 500H IAW SRM 53-00-03 PAGE202, REPAIR 1.SDR CALA2013061200402Skin · crackedR1 DOOR LOWER INTERNAL SKIN HAS A CRACK JUST ABOVE COVER PLATE CUTOUT. INSTALLED REPAIR REF ECRA 5210-02390.SDR CALA2013061200400Attach Bracket · corrodedNR 2 ENGINE AFT PYLON FAIRING BOTTOM INBD ANGLE BRACKET HAS PITTED CORROSION. R & R ATTACH BRACKET IAW SRM 51-40-02 AND DWG 31-3A2400, REV L.SDR CALA2013061200399Skin · corrodedNR 2 ENGINE AFT PYLON FAIRING BOTTOM AFT SKIN HAS PITTED CORROSION. R & R IAW SRM 51-40-02 AND DWG 313A2400, REV L.SDR CALA2013061200398Angle · corrodedR2 DOOR HAS CORROSION ON MOST BOTTOM FWD FORMED ANGLE EXTENDING INTO LEVELING COMPOUND. R & R BOTTOM FWD ANGLE REF SRM 51-40-02.SDR CALA2013061200397Frame · gougedFRAME AT BS 947.5 GOUGED BELOW RT TRANSITION PANEL. TRIMMED OUT DAMAGE AND INSTALLED REPAIR DOUBLER REF ECRA 5311-01609.SDR CALA2013061200396Door Frame · brokenR1 DOOR FRAME AT BS 312 HAS A CORNER BROKEN OFF AT STR 17R. TRIMMED OUT DAMAGED AREA AND INSTALLED REPAIR DOUBLER REF ECRA 5311-01608.SDR CALA2013060700386Cargo Track · crackedAFT CARGO BAY, CARGO TRACK CRACKED BS 727G TO 767. REMOVED AND INSTALLED CARGO TRACK IAW SRM 51-40-02.SDR CALA2013060700389Support Frame · damagedAFT FAIRING SUPPORT FRAME HAS DAMAGED NUTPLATE HOLE AND FRETTING AT BS 727 APPROX, RBL 10. INSTALLED NEW FRAME IAW SRM 51-40-02. FRAME HAS BEEN REPLACED AT BS 727 IAW SRM 51-40-02 AND SRM 51-40-05.SDR CALA2013060300384Attach Angle · corrodedFWD CARGO COMPARTMENT AFT BULKHEAD CENTER WALL LOWER ATTACH ANGLE FOR PANEL AT BS 500I, BETWEEN S-26L AND S-26R HAS CORROSION. REMOVED AND INSTALLED NEW ANGLE (RAIL ASSY) PN 143A9485Y35, REF SRM 51-40-02.SDR CALA2013060300383Angle · corrodedR2 DOOR ANGLE ATTACHED TO LOWER CENTER INTERCOSTAL HAS CORROSION UNDER LEVELING COMPOUND. R & R LOWER CENTER ANGLE REF SRM 51-40-02.SDR CALA2013060300378Baffle · crackedFOUND BAFFLE ON RT SIDE UNDER TRANSITION PANEL FWD CARGO FROM BS 500G-500H TO BE CRACKED. REMOVED AND INSTALLED NEW BAFFLE IAW SRM 51-40- 02.SDR CALA2013060300377Transition Panel · corrodedFWD CARGO BAY TRANSITION PANELS HAVE SURFACE CORRSION SEVERAL AREAS LT SIDE BS 460 TO 500I. REMOVED CORROSION, FOUND WITHIN LIMITS IAW SRM 53-00-53, FIG 103. R & R TRANSITION PANEL IAW SRM 53-00-05 REPAIR 5SDR CALA2013060300376Floorbeam · corrodedCORROSION ON FLOORBEAM AFT OF BS 270, LBL 12 TO RBL 12 COCKPIT ENTRY. INSTALLED REPAIR DOUBLER IAW ECRA 5321-01849.SDR CALA2013060300375Transition Panel · corrodedRT TRANSITION PANELS HAVE SURFACE CORROSION IN FWD CARGO COMPT STA 490 TO STA 500I R & R TRANSITION PANELS FROM STA 940 TO STA 50 0E REF SRM 53-00-53, REPAIR 5, TRANSITION PANELS FROM STA. 500E TO STA. 500I TO BE WITHIN LIMITS REF SRM 53-00-53.SDR CALA2013060300374Floor Panel · damagedCABIN FLOOR PANEL 232NF IS DAMAGED. FABRICATED NEW FLOOR PANEL IAW ECRA-5320-01448, REV G.SDR CALA2013060300373Angle · corrodedLIGHT SURFACE CORROSION ON R2 DOOR ZEE ANGLE FROM BS 986 - 1006. R & R ZEE ANGLE IAW SRM 51-40-02.SDR CALA2013060300372Angle · corrodedLIGHT TO MODERATE CORROSION ON L2 DOOR ZEE ANGLE FROM BS 947 TO 986, SEVERAL SPOTS CAPSULATED BOLT HEADS AND EDGE SEALED, REPLACEED ZEE ANGLE, REF SRM 51-40-02.SDR CALA2013060300371Web · damagedFLOOR WEB DAMAGED AND CORRODED AT BS 986.5 TO 1016 AT LBL 45 - 50. R & R WEB IAW SRM 51-40-02.SDR CALA2013060300370Floorbeam · corrodedFLOORBEAM AT BS 947 AND RBL 54 HAS CORROSION UNDER LAV MOUNT AREA. TRIMMED OFF CORRODED SECTION OF UPPER TEE AND SPLICED IN NEW SECTION FROM RBL 43 TO RT OTBD END IAW SRM 53-70-51, REPAIR 5 ALTERNATIVE 2.SDR CALA2013052700357Angle · corrodedR-1 Z-ANGLE CORRODED BS 294 TO 328 CABIN FWD ENTRY REMOVED AND INSTALLED NEW INNER CHORD (R 1 ZEE ANGLE) IAW SRM 51 -10-02 AND 51-40-02.SDR CALA2013052700356Seat Track · wornLEFT OTBD SEAT TRACK WORN ON CROWN AREA AT BS 540. CUT OUT DAMAGE AND INSTALLED NEW SECTION OF SEAT TRACK REF SRM 53-00-52, REPAIR 2.SDR CALA2013052700355Seat Track · wornRT INBD SEAT TRACK WORN FROM BS 540- 553 CUT OUT DAMAGE AND INSTALLED NEW SECTION OF SEAT TRACK REF SRM 53-00-52, REPAIR 3.SDR CALA2013052700354Seat Track · corrodedLEFT OTBD SEAT TRACK HAS CORROSION THAT WAS BLENDED OUT OF LIMITS AT BS 732. INSTALLED REPAIR REF SRM 53-00-52, REPAIR 3.SDR CALA2013052700353Floorbeam · corrodedLIGHT SURFACE CORROSION ALONG FLOORBEAM BS 986 FROM L2 DOOR ''Z'' ANGLE TO R2 DOOR ''Z'' ANGLE SEVERAL SPOTS CUT AND REMOVED UPPER FLANGE PLUS EXISTING REPAIR FROM LBL 50 T O RBL 50. INSTALLED REPAIR REF SRM 53-70-51, REPAIR 4.SDR CALA2013052300340Frame · crackedFRAME CRACKED BS 400 BETWEEN S8-9L. REPAIRED FRAME IAW EA5310-04716, REV E.
Back to N18223