N936AN
Service difficulty reports · 208
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 = 'N936AN' 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 = 'N936AN' 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 AALA20130208001Fseu · inoperativeDFW - CREW REPORTED FLAP ASYMMETRY INDICATION. EMERGENCY DECLARED FLIGHT LANDED DFW WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED FLAP SLAT ELECTRONICS UNIT. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20120320006Door Frame · corrodedCORROSION IN AFT CARGO DOOR JAMB LOWER ENTRY WEB. REPLACED WEB PER AARD 51-10-05 AND BOEING DWG 146A8123.SDR AALA20120319018Skin · damagedFORWARD CARGO DOOR HAS NICK IN EDGE OF OUTER DOOR SKIN BELOW NUMBER 2 BEAM. INSTALLED A DOUBLER REPAIR TO OUTER SKIN FORWARD EDGE AT NUMBER 2 BEAM PER EA COMP-52-022492 AND SRM 52-00-01-2R 2.SDR AALA20120316019Web · corrodedAFT CABIN WET AREA CORRODED AT RIGHT BUTTLINE 29 AND STATION 1016+2. INSTALLED REPAIR DOUBLER PER SRM 51-70-13-R1 AND 54-40-02 AND EA.SDR AALA20120316017Skin · scratchedFORWARD CARGO DOOR EXTERNAL SKIN HAS DEEP LONG SCRATCHES LOCATED BELOW HANDLE NUMBER 4. REMOVED SKIN AND INSTALLED NEW SKIN PER ESO 60654.SDR AALA20120315018Skin · damagedFORWARD CARGO DOOR EXTERNAL SKIN HAS DEEP LONG SCRATCHES LOCATED BELOW HANDLE NUMBER 4. REMOVED DAMAGED OUTER SKIN AND INSTALLED A NEW OUTER SKIN PER ESO 60654.SDR AALA20120315017Frame · crackedFRAME CRACKED AT AIR CONDITIONING SUPPORT FITTING AT STATION 380.STRINGER 9 RIGHT. INSTALLED REPAIR ANGLE PER ECO J1159-0007.SDR AALA20120315012Skin · damagedINTERIM REPAIR INSTALLED AT STATION 500D, STRINGER 22 RIGHT. REMOVED AND REPLACED DOUBLER PER EA B737-53-022403 AND SRM 53-00-01-2R-1.SDR AALA20120315009Trans Panel · corrodedRIGHT TRANSITION PANEL FROM STATIONS 767 TO 787 CORRODED. REPLACED TRANSITION PANEL PER AARD 51-10-05.SDR AALA20120315006Skin · dentedAFT CARGO DOOR EXTERNAL SKIN SURFACE HAS SHALLOW 1 INCH DENT ABOVE DOUBLE ROW OF RIVETS. REMOVED DAMAGED SKIN AND REPLACED WITH NEW SKIN PER ESO 60651.SDR AALA20120314018Skin · damagedE&E ACCESS DOORSKIN SCRATCHED AND SAND PITTED FORWARD TO AFT. REMOVED AND INSTALLED NEW SKIN PER EA COMP-52-022392.SDR AALA20120314017Intercostal · crackedCRACKED INTERCOSTAL AT STATIONS 312 TO 328 44 LEFT BUTTLINE. REPLACED INTERCOSTAL PER AARD 51-0-05-1.SDR AALA20120313031Intercostal · crackedCRACKED INTERCOSTAL AT STATIONS 312 TO 328, RIGHT BUTTLINE 32. REPLACED INTERCOSTAL PER AARD 51-0-05-1.SDR AALA20120316016Fitting · crackedCARGO FLOOR SUPPORT FORWARD BAFFLE CLIP CRACKED AT LEFT TRANSITION PANEL AND STATION 500F. REPLACED BAFFLE CLIPS PER EA B737-53-022292.SDR AALA20120316015Fitting · crackedCARGO FLOOR SUPPORT AFT AND FORWARD BAFFLE CLIPS CRACKED AT LEFT TRANSITION PANEL AND STATION 500G. REPLACED BAFFLE CLIPS PER EA B737-53-022292.SDR AALA20120316014Fitting · crackedCARGO FLOOR SUPPORT AFT AND FORWARD BAFFLE CLIPS CRACKED AT RIGHT TRANSITION PANEL AND STATION 500H. REPLACED BAFFLE CLIPS PER EA B737-53-022292.SDR AALA20120316013Fitting · crackedCARGO FLOOR SUPPORT AFT AND FORWARD BAFFLE CLIPS CRACKED AT RIGHT TRANSITION PANEL AND STATION 500G. REPLACED BAFFLE CLIPS PER EA B737-53-022292.SDR AALA20120316012Fitting · crackedCARGO FLOOR SUPPORT AFT AND FORWARD BAFFLE CLIPS CRACKED AT LEFT TRANSITION PANEL AND STATION 500H. REPLACED BAFFLE CLIPS PER EA B737-53-022292.SDR AALA20120316002Stiffener · corrodedAUXILIARY POWER UNIT COMPARTMENT INLET CUTOUT AT STATION 1125, VERTICAL STIFFENER IS CORRODED. INSTALLED VERTICAL STIFFENER AT STATION 1125 INLET CUTOUT PER AARD 51-10-05 REPAIR 1 AND BOEING DRAWING 148A8650.SDR AALA20120316001Stiffener · corrodedAUXILIARY POWER UNIT COMPARTMENT, HORIZONTAL STIFFENER FROM STATIONS 1088 TO 1138 IS CORRODED AT INLET CUTOUT LOWER END. INSTALLED LOWER HORIZONTAL STIFFENER FROM STATIONS 1088 TO 1138 IN AUXILIARY POWER UNIT COMPARTMENT INLET CUTOUT PER AARD 51-10-05 REPAIR SDR AALA20120308017Fitting · crackedCARGO FLOOR SUPPORT FORWARD BAFFLE CLIP CRACKED AT RIGHT TRANSITION PANEL AND STATION 500F. REPLACED BAFFLE CLIPS PER EA B737-53-022292.SDR AALA20120314002Frame · damagedVERTICAL FRAME AT STATION 291.5 HAS DOUBLE DRILLED HOLE ABOVE CREASE ANGLE. INSTALLED FREEZE PLUG PER EA.SDR AALA20120314006Intercostal · crackedCABIN FLOOR INTERCOSTAL FROM STATION 277 TO 291.5 CRACKED AT BOTH CLIP NUT HOLES. REMOVED AND REPLACED INTERCOSTAL PER AARD 51-10-05 AND BOEING DRAWING 1415400.SDR AALA20120314005Intercostal · crackedCABIN FLOOR INTERCOSTAL FROM STATIONS 328 TO 344 CRACKED AT CLIP NUT HOLES. REMOVED AND REPLACED INTERCOSTAL PER AARD 51-10-05 AND BOEING DRAWING 1415400.SDR AALA20120314001Frame · crackedFRAME CRACKED AT AIR CONDITIONING SUPPORT FITTING STATION 500A R. ACCOMPLISHED NESTED ANGLE REPAIR PER ESO J1159AD.SDR AALA20120313008Frame · crackedFRAME CRACKED AT AIR CONDITIONING SUPPORT FITTING STATION 500C-R. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AD-0007.SDR AALA20120312006Angle · corrodedCREASE ANGLE CORRODED AT FORWARD SERVICE DOOR THRESHOLD STATIONS 312 TO 328. INSTALLED NEW CREASE ANGLE PER AARD 51-10-05-1 AND BOEING DRAWING 141A8310.SDR AALA20120311003Frame · crackedEDDY CURRENT INSPECTION INDICATES A CRACK AT STATION 440 LEFT FRAME AT AIR CONDITIONING SUPPORT ATTACH FITTING. INSTALLED REPAIR DOUBLER/ANGLES A AND B PER ECO J1159AD 0006.SDR AALA20120311002Frame · crackedEDDY CURRENT INSPECTION INDICATES A CRACK AT STATION 400 LEFT FRAME AT AIR CONDITIONING SUPPORT ATTACH FITTING. INSTALLED REPAIR DOUBLER/ANGLES A &AND B PER ECO J1159AD CARD 0006.SDR AALA20120311001Frame · crackedEDDY CURRENT INSPECTION INDICATES A CRACK AT STATION 380 LEFT AT AIR CONDITIONING SUPPORT ATTACH FITTING. INSTALLED REPAIR DOUBLER/ANGLES A AND B PER ECO J1159AD 0006.SDR AALA20120323008Skin · dentedINTERIM DOUBLER REPAIR PERFORMED TO DENT WITH GOUGE BETWEEN AT STATIONS 887 TO 907 STRINGERS 22 AND 23 LEFT. PERMANENT REPAIR DOUBLER INSTALLED PER EA B737-55-022588.SDR AALA20110903TUL02Angle · crackedBULKHEAD VAPOR BARRIER STIFFENER ANGLE CRACKED. REMOVED AND REPLACED STIFFENER ANGLE PER SRM 51-10-2, AARD 51-00-05-1 AND EA B737-57-018937.SDR AALA20110729DFW02Battery Pack · dischargedCABIN EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK.SDR AALA20110413ORD01Sensor · damagedORD - CREW REPORTED LEFT WING TO BODY OVERHEAT LIGHT ILLUMINATED WITH APU AND WING ANTI ICE OFF AT THE TIME. ACCOMPLISHED QRH PROCEDURES AND LIGHT WENT OFF AFTER LEFT PACK SHUT OFF. AFTER INITIAL DESCENT LIGHT CAME BACK ON AND WOULD NOT GO OUT. EMERGENCY DESDR AALA20120314023Frame · crackedFRAME CRACKED AT AIR CONDITIONING SUPPORT STATION 440 R. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AD.SDR AALA20120314022Frame · crackedFRAME CRACKED AT AIR CONDITIONING SUPPORT FITTING STATION 480 R. ACCOMPLISHED NESTED REPAIR ANGLE PER ECO J1159AD.SDR AALA20120313005Door Frame · crackedRIGHT NUMBER 1 DOOR STUB FRAME CRACKED AT STATION 294 AT FLOOR LINE. INSTALLED REPAIR PER SRM 51-70-11.SDR AALA20120312028Frame · crackedFRAME CRACKED AT AIR CONDITIONING SUPPORT FITTING STATION 727B-R. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AD-0007.SDR AALA20110129DFW01Sign · brokenRIGHT AFT OVERWING EXIT SIGN BROKEN AND MISSING LENS. REPLACED LIGHT ASSEMBLY FOR RIGHT AFT OVERWING EXIT SIGN. OPS CHECK NORMAL.SDR AALA20100823TUL05Skin · damagedSKIN DAMAGED ON FORWARD CARGO DOOR. INSTALLED NEW SKIN ON FORWARD CARGO DOOR AS PER ESO 60654.SDR AALA20100117DFW01Light · inoperativeEMERGENCY LIGHT AT LEFT FORWARD SLIDE INOPERATIVE. REPLACED LAMP.SDR AALA20090821TUL01Intercostal · crackedINTERCOSTAL AT STATION 312 TO 328 CRACKED. INSTALLED NEW INTERCOSTAL PER SRM 53-10-04.SDR AALA2009061700005Control Valve · inoperativeIAD - INFLIGHT MIA-DCA. ANTI-SKID FAULT LIGHT ILLUMINATED AFTER GEAR RETRACTION ON TAKEOFF. EMERGENCY DECLARED, LANDED IAD WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED ANTI-SKID AUTO BRAKE CONTROLLER AND LEFT ALTERNATE CONTROL VALVE V125.SDR AALA2009031700603Connector · looseDFW - SEAT MOUNTED ESCAPE PATH LIGHTING AT SEAT 10D INOPERATIVE. REPAIRED LOOSE CONNECTOR FOR SEAT MOUNTED ESCAPE PATH LIGHTING AT SEAT 10D.SDR AALA2009031700602Wire · brokenDFW - SEAT MOUNTED ESCAPE PATH LIGHTING AT SEAT 19D INOPERATIVE. REPAIRED BROKEN WIRE IN SIDEWALL.SDR AALA20071609Battery Pack · inoperativeTUL - EMERGENCY LIGHTS AT MID COACH CLASS INOPERATIVE. REPLACED BATTERY PACK AT SEAT 19A FOR EMERGENCY LIGHTS AT MID COACH CLASS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071285Bulb · burned outDFW - EMERGENCY EXIT FLOOD LIGHT AT SEAT ROW 14A INOPERATIVE. RELAMPED EMERGENCY EXIT FLOOD LIGHT AT SEAT ROW 14A. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070980Connector · looseMIA - EMERGENCY LIGHT AT SEAT 12D INOPERATIVE. SECURED CONNECTOR FOR EMERGENCY LIGHT AT SEAT 12D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070139Lens · missingMIA - EMERGENCY LIGHT AT SEAT 22D HAS MISSING LENS COVER. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 22D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070138Bulb · burned outMIA - EMERGENCY LIGHT AT SEAT 22D INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 22D. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to N936AN