N949AN
Service difficulty reports · 181
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 = 'N949AN' 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 = 'N949AN' 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 AALA20120712024Frame · crackedTHE RIGHT FRAME AT AIR CONDITION RAIL ATTACH IS CRACKED AT INBOARD FASTENER AT STATION 500A. INSTALLED REPAIR ANGLES PER ECO J1159AD.SDR AALA20120712014Transition Panel · corrodedTHE RIGHT TRANSITION PANEL IS CORRODED UPPER AND LOWER SIDES AT STATION 767 TO 787. REMOVED AND REPLACED THE TRANSITION PANEL PER AARD 51-01-05-R1.SDR AALA20120720002Stiffener · corrodedTHE 1125 VERTICAL STIFFNER IS CORRODED AT AUXILIARY POWER UNIT INLET. INSTALLED VERTICAL STIFFENER AT STATION 1125 PER AARD 51-10-05 AND BOEING DRAWING 148A8650.SDR AALA20120720001Stiffener · corrodedLOWER HORIZONTAL STIFFENER FROM STATIONS 1088 TO 1145 HAS CORROSION AT THE LOWER AUXILIARY POWER UNIT INLET. INSTALLED HORIZONTAL STIFFENER AT STATIONS 1088 TO 1145 PER AARD 51-10-05 AND BOEING DRAWING 148A8650.SDR AALA20120710016Vapor Barrier · crackedRIGHT VAPOR BARRIER CRACKED APPROXIMATELY 2.25 INCHES AT INBOARD EDGE OF PACK EXHAUST DUCT. INSTALLED CROSS BRACE REPAIR STRAPS AND ANGLES AT BAYS 2R AND 4R PER / SRMSUP 57-10-10-2R.SDR AALA20120709005Intercostal · crackedINTERCOSTAL FLOOR SUPPORT CRACKED AT CLIP NUT HOLE AT LEFT BUTTLINE 45 BETWEEN STATIONS 312 AND 328. INSTALLED NEW SERVICEABLE INTERCOSTAL PER AARD 51-10-05-R1.SDR AALA20120709004Intercostal · crackedINTERCOSTAL FLOOR SUPPORT CRACKED AT CLIP NUT HOLE AT LEFT BUTTLINE 45 BETWEEN STATIONS 328 AND 344. INSTALLED NEW SERVICEABLE INTERCOSTAL PER AARD 51-10-05-R1.SDR AALA20120708006Angle · corrodedRIGHT NUMBER 1 DOOR, PANEL AT LOWER CORNER (DOOR CUT-OUT), INBOARD LEG OF PANEL, HAS CRACKED AT CREASE ANGLE ATTACH POINT. INSTALLED REPAIR ANGLE PER SRM 51-70-11-2R.SDR AALA20120711005Threshold · corrodedTHRESHOLD WEB FROM STATIONS 795 TO 847 CORRODED. REPLACED WEB AREA PER AARD 51-10-05.SDR AALA20120221004Intercostal · crackedINTERCOSTAL CRACKED AT BL 0, BETWEEN BS 344 AND 360. INSTALLED REPLACEMENT INTERCOSTAL PER AARD 51-00-05-1.SDR AALA20120220009Intercostal · crackedINTERCOSTAL AT LBL 10, BETWEEN BS 344 TO 360 CRACKED. INSTALLED REPLACEMENT INTERCOSTAL PER AARD 51-00-05-1.SDR AALA20120220004Intercostal · crackedINTERCOSTAL CRACKED LBL 46, BETWEEN BS 312 TO 328. INSTALLED REPLACEMENT INTERCOSTAL PER AARD 51-00-05-1.SDR AALA20110828LAX01Fseu · faultedLAX - CREW REPORTED LEADING EDGE FLAP TRANSIT LIGHT ILLUMINATED IN FLIGHT. EMERGENCY DECLARED FLIGHT LANDED LAX WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND SLAT NUMBER 6 SENSOR FAULT. REPLACED FLAP SLAT ELECTRONIC UNIT. SYSTEM GROUND CHECK NORMSDR AALA20110420DFW01Cabin Pressure · malfunctionedCREW REPORTED CABIN ALT WARNING HORN AT 10,000 CABIN ALTITUDE IN CLIMBOUT AND BOTH ENGINE BLEED SWITCH WERE IN OFF POSITION. O2 MASKS WERE DEPLOYED. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. AIRCRAFT IS SDR AALA20100207TUL07Skin · damagedDENTS ON AFT CARGO DOOR OUTER SKIN. REMOVED DAMAGED SKIN AND REPLACED WITH NEW SKIN PER 51-31-14.SDR AALA20091023DFW02Cradle · brokenEMERGENCY FLASHLIGHT CRADLE AT FLIGHT ATTENDANT FIRST CLASS OUTBOARD BROKEN. REPLACED CRADLE.SDR AALA20090814TUL17Skin · dentedFUSELAGE SKIN AND STRINGER DAMAGED AT STATION 320 STRINGER 3 LEFT. INSTALLED DOUBLER AND TRIPLER AND U-CHANNEL IN STRINGER UNDER EA B737-53-007048.SDR AALA2009031400587Lens · wrong partMIA EMERGENCY LIGHT AT SEAT 12D HAS WRONG COLOR LENS. REPLACED EMERGENCY LIGHT AT SEAT 12D WITH CORRECT COLOR OF LENS.SDR AALA2009012500191Door · not seatedDFW INFLIGHT - CREW REPORTED PRESSURIZATION PROBLEM. RETURNED TO DFW AND LANDED WITHOUT INCIDENT. FOUND FORWARD ENTRY DOOR AFT END NOT FULLY SEATED IN FRAME. INSPECTED DOOR AND FRAME. CYCLED DOOR SEVERAL TIMES. NO INDICATION OF RIG PROBLEM. DOOR FUNCTIONSDR AALA200803211Lamp · burned outMIA - EMERGENCY LIGHT AT SEAT 9D INOPERATIVE. REPLACED LAMP AT 9D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800333Battery Pack · inoperativeTUL - EMERGENCY LIGHT BATTERY PACK FOR LEFT MID TO AFT CABIN FAILED TEST. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT LEFT MID TO AFT CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071576Bulb · inoperativeMIA - EMERGENCY LIGHT AT SEAT ROW 17D INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT ROW 17D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071375Lens · missingDTW - EMERGENCY LIGHT AT RIGHT NUMBER FOUR DOOR MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT RIGHT NUMBER FOUR DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071203Bulb · burned outMIA - EMERGENCY LIGHT AT SEAT 16D INOPERATIVE. RELAMPED EMERGENCY LIGHT SAT SEAT ROW 16D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060998Battery Pack · dischargedMIA - EMERGENCY LIGHT AT SEAT 21D INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHT AT SEAT 21D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060997Light · inoperativeMIA - EMERGENCY SEAT MOUNTED LIGHTS IN FIRST CLASS CABIN INOPERATIVE. RELAMPLED EMERGENCY SEAT MOUNTED LIGHTS IN FIRST CLASS CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060996Light · inoperativeMIA - EMERGENCY LIGHTS IN AFT RIGHT SIDE OF CABIN INOPERATIVE. RELAMPED EMERGENCY LIGHTS IN AFT RIGHT SIDE OF CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060666Pseu · malfunctionedLGA - DURING INITIAL CLIMB-OUT, RIGHT MAIN GEAR RED LIGHT REMAINED ILLUMINATED WITH GEAR HANDLE IN OFF POSITION. RECYCLED GEAR HANDLE AND RED LIGHT WENT OUT. LANDED LGA WITHOUT INCIDENT. REPLACED PROXIMITY SENSOR ELECTRONICS UNIT AS PRECAUTION. SYSTEM GROUSDR AALA20050686Battery Pack · inoperativeTUL - BATTERY PACKS FOR EMERGENCY LIGHTS FOR COACH AND FIRST CLASS SEATS INOPERATIVE. REPLACED BATTERY PACK AT STATIONS 727, 559, 947.5, AND 328 FOR EMERGENCY LIGHTS IN COACH AND FIRST CLASS SEATS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040197Battery Pack · inoperativeRNO RIGHT HAND UPPER EMERGENCY LIGHT AT SEAT 11D INOPERATIVE. REPLACED BATTERY PACK FOR RIGHT HAND UPPER EMERGENCY LIGHT AT SEAT 11D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20011844Light · inoperativeMIA - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT LIGHT AT R1 DOOR INOPERATIVE. REPLACED EMERGENCY EXIT LIGHT ASSEMBLY AT R1 DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)
Back to N949AN