N937AN
Service difficulty reports · 203
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 = 'N937AN' 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 = 'N937AN' 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 AALA20120511010Sensor · inoperativeMIA - CREW REPORTED AFTER TAKEOFF FLAPS WOULD NOT RETRACT. FLIGHT RETURNED MIA LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED INTERLOCK SENSOR. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20120419029Web · corrodedCORROSION FROM STATIONS 747 TOP 847. REPLACED WEB.SDR AALA20120419015Transition Panel · damagedFASTENER HEADS PULLING THROUGH LEFT TRANSITION PANEL FROM BETWEEN 8 INCHES AFT OF STATION 727G AND 8 INCHES AFT OF STATION 747. INSTALLED NEW LEFT TRANSITION PANEL BETWEEN 8 INCHES AFT OF STATION 727G AND 8 INCHES AFT OF STATION 747 PER SRM 53-00-53-2R5 AND ESDR AALA20120419008Transition Panel · corrodedLEFT TRANSITION PANEL IN AFT CARGO CORRODED FROM STATIONS 787 TO 812. REMOVED DAMAGED TRANSITION PANEL AND INSTALLED NEW LEFT TRANSITION PANEL FROM STATIONS 787 TO 812 PER SRM 53-00-53-2R 5.SDR AALA20120414005Transition Panel · damagedFASTENER HEAD PULLING THROUGH THE AFT CARGO RIGHT TRANSITION PANEL AT 727F. REPLACED RIGHT TRANSITION PANEL PER EA B737-53-022848 AND SRM 53-00-53-2R6.SDR AALA20120414004Transition Panel · damagedFASTENER HEAD PULLED THROUGH THE AFT CARGO RIGHT TRANSITION PANEL AT STATION 727 E. REPLACED RIGHT TRANSITION PANEL PER EA B737-53-022848 AND SRM 53-00-53-2R6.SDR AALA20120414003Transition Panel · damagedFASTENER HEAD PULLING THROUGH THE RIGHT TRANSITION PANEL AT STATION 727C. REPLACED RIGHT TRANSITION PANEL PER EA B737-53-022848 AND SRM 53-00-53-2R6.SDR AALA20120414002Transition Panel · corrodedAFT CARGO RIGHT TRANSITION PANEL CORRODED FROM STATIONS 727H TO 727J. REPLACED TRANSITION PANEL PER EA B737-53-022848 AND SRM 53-00-53-2R6.SDR AALA20120413018Skin · dentedSIX DENTS FOUND AT AFT CARGO DOOR ABOVE FORWARD AND AFT OF DOOR HANDLE. REMOVED AND REPLACED AFT CARGO DOOR SKIN PER ESO 60651.SDR AALA20120413017Skin · dentedDENT ON EXTERIOR FORWARD CARGO DOOR 7 INCHES UP FROM HANDLE. REMOVED DAMAGED SKIN AND REPLACED WITH NEW SKIN PER ES0 60654.SDR AALA20120412013Web · damagedBS 1020 LEFT BUTTLINE 19, HOLE IN AFT DECK WEB AND BS 1020 LEFT BUTTLINE 31, DAMAGE IN AFT DECK WEB. INSTALLED WEB AND STRAPS IN AREA INDICATED PER AARD 51-10-05-1 AND EA B737-53-022860.SDR AALA20120411004Stiffener · corrodedAUXILIARY POWER UNIT COMPARTMENT INLET CUTOUT STATION 1125 VERTICAL STIFFENER IS CORRODED. REPLACED APU COMPARTMENT INLET CUTOUT STATION 1125 VERTICAL STIFFENER PER AARD 51-10-05.SDR AALA20120410019Intercostal · corrodedCORROSION ON INTERCOSTAL FROM STATIONS 277 TO 294. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA20120406007Frame · crackedHIGH FREQUENCY EDDY CURRENT SHOWS POSITIVE CRACK INDICATION IN FRAME AT BIN SUPPORT RAIL BRACKET STATION 500C RIGHT BETWEEN STRINGERS 8 AND 9 RIGHT. INSTALLED REPAIR ANGLE PER ECO J1159AD-006.SDR AALA20120406006Frame · crackedHFEC SHOWS POSITIVE CRACK INDICATION IN FRAME AT BIN SUPPORT RAIL BRACKET STATION 480 RIGHT. INSTALLED REPAIR DOUBLER ON FRAME AT RIGHT BIN SUPPORT RAIL BRACKET STATION 480R PER ECO J1159AD-006.SDR AALA20120406005Frame · crackedFRAME AT STATION 480, VISUAL INDICATION OF CRACK AT LEFT BIN RAIL ATTACH BRACKET LOCATION. COMPLETED DOUBLER REPAIR AT STATION 480L FRAME PER ECO J1159AD.SDR AALA20120421005Floor Support · corrodedAFT CARGO FLOORBOARD SUPPORT CORRODED JUST INBOARD OF DOOR CUTOUT BETWEEN STATIONS 790 TO 847. INSTALLED FLAT REPAIR STRAP PER EA B737-53-023211.SDR AALA20120423003Floor Support · corrodedFLOORBOARD SUPPORT CORRODED AT STATION 887 ABOVE STRINGER 25 LEFT AND 25 RIGHT. INSTALLED NEW FLOORBOARD SUPPORT AT STATION 887 PER SRM 53-60-53.SDR AALA20120411007Intercostal · crackedINTERCOSTAL BETWEEN STATIONS 344 TO 360 LEFT BUTTLINE 1 HAS VISUAL INDICATION OF CRACK IN TOP FLANGE. REPLACED INTERCOSTAL BETWEEN STATIONS 344 TO 360 LEFT BUTTLINE 1 PER AARD 51-10-05.SDR AALA20120409015Frame · crackedHFEC SHOWS POSITIVE CRACK INDICATION IN FRAME AT AIR CONDITIONING RAIL BRACKET STATION 500D RIGHT. INSTALLED REPAIR DOUBLERS PER ECO J1159AD.SDR AALA20120409014Frame · crackedHFEC SHOWS POSITIVE CRACK INDICATION IN FRAME AT AIR CONDITIONING RAIL BRACKET STATION 500A RIGHT. INSTALLED REPAIR DOUBLERS PER ECO J1159AD.SDR AALA20120406018Frame · crackedHFEC SHOWS POSITIVE CRACK INDICATION IN FRAME AT A/C RAIL BRACKET STATION 400R. FRAME DOUBLER REPAIR INSTALLED PER ECO J1159AD CARD 0007.SDR AALA20120406004Frame · crackedFRAME AT BS 400, VISUAL INDICATION OF CRACK AT LEFT BIN RAIL ATTACH BRACKET LOCATION. DOUBLER REPAIR INSTALLED ON FRAME AT STATION 400 LEFT PER ECO J1159AD CARD 0006.SDR AALA20120422014Skin · dentedDENT IN FUSELAGE SKIN BETWEEN STATION 500G AND 500H AND BETWEEN STRINGERS 25 AND 26 RIGHT. INSTALLED 10.5 BY 11 INCH BLIND FASTENER REPAIR DOUBLER PER SRM 53-00-01-2R 4.SDR AALA20120410026Intercostal · crackedINTERCOSTAL BETWEEN STATIONS 212 TO 328 LEFT BUTTLINE 46 CRACKED. INSTALLED INTERCOSTAL BETWEEN STATIONS 212 TO 328 LEFT BUTTLINE 46 PER AARD 51-10-05.SDR AALA20120410025Intercostal · crackedINTERCOSTAL BETWEEN STATIONS 212 TO 328 RIGHT BUTTLINE 30 CRACKED. INSTALLED INTERCOSTAL BETWEEN STATIONS 212 TO 328 RIGHT BUTTLINE 30 PER AARD 51-10-05.SDR AALA20120409005Frame · crackedHFEC SHOWS POSITIVE CRACK INDICATION IN FRAME AT AIR CONDITIONING RAIL BRACKET STATION 727B RIGHT. INSTALLED DOUBLER REPAIR PER J1159AD CARD 0007.SDR AALA20120409004Frame · crackedHFEC SHOWS POSITIVE CRACK INDICATION IN FRAME AT AIR CONDITIONING RAIL BRACKET STATION 827 RIGHT. INSTALLED DOUBLER REPAIR PER J1159AD CARD 0007.SDR AALA20120409003Frame · crackedHFEC SHOWS POSITIVE CRACK INDICATION IN FRAME AT AIR CONDITIONING RAIL RACKET STATION 867 RIGHT. INSTALLED DOUBLER REPAIR PER J1159AD CARD 0007.SDR AALA20120409002Frame · crackedHFEC SHOWS POSITIVE CRACK INDICATION IN FRAME AT AIR CONDITIONING RAIL BRACKET BS 727D RIGHT. INSTALLED DOUBLER REPAIR PER J1159AD CARD 0007.SDR AALA20100805TUL02Floorboard · crackedAFT CARGO COMPARTMENT FLOOR HAS A CRACK JUST FORWARD OF THE SLIDING CARPET. REPAIRED CRACK PER AARD 53-00-00-5 AND EA B737-53-012173.SDR AALA20100727TUL37Bulkhead · canningOIL CANNING AT STATION 1016 AFT PRESSURE BULKHEAD AT STRINGER 3 TO 4 LEFT. REPAIRED AFT PRESSURE BULKHEAD PER EA B737-53-011871.SDR AALA20100726TUL07Shear Tie · damagedTWO EACH TOOLING DRILL MARKS IN SHEAR TIE STATION 907 BETWEEN LONGERON 2 AND LONGERON 3. NEW SHEAR TIE MANUFACTURED IN SHOP. INSTALLED NEW SHEAR TIE PER SRM 51-10-2.SDR AALA20100724TUL07Shear Tie · damagedTOOLING MARKS ON SHEAR TIE AND LOWER FRAME AT STATION 907 BETWEEN L1 AND L2. INSTALLED SHEAR TIE PER SRM 51-10-02.SDR AALA20100723TUL14Beltframe · damagedSTATION 887 TOOLING DAMAGE BETWEEN 3L AND 2L IN RADIUS OF FRAME. ACCOMPLISHED REPAIR PER SRM 51-70-11-2R.SDR AALA20100721TUL04Floorbeam · corrodedCORROSION ON TOP OF FLOORBEAM STATION 986.5 AND APPROX RIGHT BUTTLINE 43. REPAIRED PER SRM 53-00-51-2R AND EA B737-53-011891.SDR AALA20100520MIA01Slide · disconnectedEMERGENCY SLIDE PARTIALLY DISCONNECTED FROM RIGHT NUMBER ONE DOOR. RE-SECURED SLIDE ON RIGHT NUMBER ONE DOOR.SDR AALA20090921TUL02Intercostal · crackedCABIN FLOOR, INTERCOSTAL CRACKED AT STATION 312 TO 320 LEFT BODY LINE 46. INSTALLED NEW INTERCOSTAL PER SRM 53-10-04.SDR AALA20090921TUL01Intercostal · crackedCABIN FLOOR, INTERCOSTAL CRACKED AT STATION 320 TO 344 LEFT BODY LINE 46. INSTALLED NEW INTERCOSTAL PER SRM 53-10-04.SDR AALA20090809MIA01Blower Motor · faultyMIA - CREW REPORTED LAVATORIES WOULD NOT FLUSH IN FLIGHT. EMERGENCY DECLARED RETURNED MIA WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND SENSOR FAULT AND BLOWER MOTOR POPPING CIRCUIT BREAKER. REPLACED BLOWER MOTOR. SYSTEM GROUND CHECKED NORMAL OPESDR AALA200802449Lamp · inoperativeEMERGENCY LIGHT AT SEAT 11D INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 11D. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA0071801Battery Pack · inoperativeTUL - EMERGENCY LIGHTS IN FORWARD COACH CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS IN FORWARD COACH CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071800Battery Pack · inoperativeTUL - EMERGENCY LIGHTS IN AFT COACH CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS IN AFT COACH CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071799Battery Pack · inoperativeTUL - EMERGENCY LIGHTS IN MID COACH CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS IN MID COACH CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071798Battery Pack · inoperativeTUL - EMERGENCY LIGHTS IN FORWARD CABIN INOPERATIVE. REPLACED BATTERY PACK AT STATION 500 FOR EMERGENCY LIGHTS IN FORWARD CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071705Shutoff Valve · inoperativeDTW INFLIGHT T873/08SEP - TOWER REPORTED FLUID LEAK FROM LEFT WING AT TAKEOFF. RETURNED TO DTW AND LANDED WITHOUT INCIDENT. FOUND FUEL LEAK FROM LEFT WING TIP DUE TO FUEL SCAVENGE SYSTEM INOPERATIVE WITH VALVE OPEN. REPLACED FLOAT OPERATED SHUTOFF VALVE. SSDR AALA20071502Light · inoperativeMIA - EMERGENCY LIGHT AT LEFT EXTERIOR NUMBER TWO DOOR INOPERATIVE.SDR AALA20071481Bulb · inoperativeMIA - EXTERIOR EMERGENCY LIGHT AT LEFT NUMBER TWO DOOR INOPERATIVE. REPLACED LAMP FOR EXTERIOR EMERGENCY LIGHT AT LEFT NUMBER TWO DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071160Power Supply · dischargedMIA - EMERGENCY LIGHTS FROM SEAT ROWS 22 TO AFT OF CABIN INOPERATIVE. RECHARGED POWER SUPPLY FOR EMERGENCY LIGHTS FROM SEAT ROWS 22 TO AFT OF CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071161Light · inoperativeMIA - EMERGENCY LIGHT IN AFT CABIN INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT IN AFT CABIN.
Back to N937AN