N974AN
Service difficulty reports · 180
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 = 'N974AN' 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 = 'N974AN' 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 AALA20130712009Skin · damagedNR 1 SLAT HAS DENT ON TE 65 INCHES FROM OTBD END & 2.5 INCHES FROM TE ON UPPER SKIN OF TE WEDGE. HOT BOND REPAIR TO BOTH ITEMS IAW SRM 51-70-10-2R-4.SDR AALA20130711001Frame · crackedHFEC & LFEC INSPECTION INDICATES CRACKS AT A/C FRAME, STATION 7271 RT. INSTALLED ANGLES, FILLER & INSTALLED FASTENERS IAWSDR AALA20130710006Frame · crackedHFEC & LFEC INSPECTION INDICATES CRACKS AT A/C FRAME, STATION 727 RT. INSTALLED ANGLES, FILLER & INSTALLED FASTENERS IAW ECO J1159AE CARD 007.SDR AALA20130710005Frame · crackedHFEC & LFEC INSPECTION INDICATES CRACKS AT A/C FRAME. STATION 727 J RT INSTALLED ANGLES, FILLER & INSTALLED FASTENERS IAWSDR AALA20130713005Web · crackedFLOOR WEB DAMAGED AT LBL 45 FROM STATIONS 986-989. INSTALLED DOUBLER ON WEB IAW SRM 51-70-13-2R-4.SDR AALA20130707002Beltframe · crackedCRACK IN BELTFRAME AT OVERHEAD BIN MOUNT, STATION 727B. ACCOMPLISHED REPAIR IAW ESO J1159-0001.SDR AALA20130705008Frame · crackedFRAME AT STATION 480 RT CRACKED AT BIN RAIL ATTACHMENT BRACKET HOLE. INSTALLED ALL FRAME REPAIR PARTS & FASTENERS IAW ECO J1159AE CARD 0007.SDR AALA20130714006Door Frame · crackedLOWER FORWARD INBD CORNER OF RT NR 1 DOOR JAMB CRACKED. INSTALLED REPAIR DOUBLER IAW SRM 51-70-11-2R.SDR AALA20130709003Beltframe · crackedCABIN BELLFRAME 867 HAS CRACK AT OVERHEAD BIN ATTACH BRACKET. CUT OUT DAMAGE & INSTALLED REPAIR DOUBLER IAW ECO J1159AE.SDR AALA20130709002Beltframe · crackedCABIN BELLFRAME 827 HAS CRACK AT OVERHEAD BIN ATTACH BRACKET. CUT OUT DAMAGE & INSTALLED REPAIR DOUBLER IAW ECO J1159AE.SDR AALA20130714004Floorbeam · corrodedAFT WET AREA, CORROSION ON STATION 986.5 FLOORBEAM FROM BUTTLINE 0 TO LBL 51. INSTALLED INTERCOSTAL IAW SRM 53-70-51-2R-4.SDR AALA20130708012Skin · damagedLT SIDE FUSELAGE HAS MULTIPLE LIGHTNING STRIKES FROM STATIONS 500A - 500I & STRINGERS 19 & 20 LEFT. INSTALLED DOUBLER FROM STATIONS 502A & 513A BETWEEN STRINGERS 19 & 21 LT IAW SRM 53-00-01-2R-1. INSTALLED RIVET AT STATION 503B BETWEEN STRINGERS 20 & 21 LT ISDR AALA20120929005Skin · damagedFUSELAGE SKIN DAMAGED, AFT OF THE CENTER OF THE LEFT NUMBER 2 DOOR AT STATION 1010. INSTALLED REPAIR DOUBLER PER EA B737-53-026314.SDR AALA20130711002Skin · dentedDENT AT STATION 480 BETWEEN STRINGERS 25 & 26 RT. DAMAGE WAS REMOVED & DOUBLER INSTALLED IAW SRM 53-00-01-2R-3.SDR AALA20120801010Battery Pack · dischargedEMERGENCY LIGHTS AT RIGHT FORWARD INOPERATIVE. REPLACED BATTERY PACK M1695 FOR EMERGENCY LIGHTS AT RIGHT FORWARD. OPS CHECK NORMAL.SDR AALA20120801003Battery Pack · dischargedMID CABIN EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK M1674 FOR EMERGENCY LIGHTS AT MID CABIN. OPS CHECK NORMAL.SDR AALA20110806ORD02Battery Pack · dischargedSEATS 15 TO 21 AND UPPER BIN ROWS 14 TO 21 FAILED FUNCTIONAL CHECK. REPLACED BATTERY PACK FOR SEATS 15 TO 21 AND UPPER BIN ROWS 14 TO 21.SDR AALA20110730SAN01Battery Pack · dischargedONE SECTION OF EMERGENCY SEAT MOUNTED LIGHTS, SEATS 15 TO 22, WOULD NOT TEST WHILE ACCOMPLISHING SIC2904. REPLACED BATTERY MODULE M1671.SDR AALA20110204DWH01Light · brokenEGRESS LIGHT HAS BROKEN BASE. REPLACED BASE. OPS CHECK NORMAL.SDR AALA20110203DWH01Wire · brokenEGRESS LAMP SEAT ROW 8 INOPERATIVE. RE-TERMINATED BROKEN WIRE AT FEEDER PLUG TO EGRESS LIGHT AT ROW 8.SDR AALA20100804TUL01Wire · brokenFOUND BROKEN WIRE AT SEAT 11D TO PATH LIGHT. REPAIRED WIRE FOR EMERGENCY LIGHT AT SEAT 11D. OPS CHECKED NORMAL.SDR AALA20100322SJU01Handle · faultySJU - INFLIGHT UVF-MIA. CREW REPORTED RIGHT ENGINE THRUST REVERSER LIGHT ILLUMINATED AND STAYED ON FOR REMAINDER OF FLIGHT. FLIGHT DIVERTED SJU LANDED WITHOUT INCIDENT. REPLACED HANDLE KIT AT LEFT SLEEVE LOCK SENSOR. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA200802425Lamp · inoperativeDFW EMERGENCY LIGHT AT RT FORWARD OVERWING INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHTS AT RT FORWARD OVERWING. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802424Lamp · inoperativeDFW EMERGENCY LIGHT AT LT FORWARD OVERWING INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHTS AT LT FORWARD OVERWING. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA20071144Light · brokenMIA - EMERGENCY LIGHT EXIT SIGN AT AFT LEFT GALLEY BROKEN. REPLACED EMERGENCY LIGHT EXIT SIGN ASSEMBLY AT AFT LEFT GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070247Bulb · burned outMIA - FOUND EMERGENCY LIGHT AT SEAT 8D INOPERATIVE. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 8D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070246Lens · inoperativeMIA - FOUND EMERGENCY LIGHT AT SEAT 8D INOPERATIVE. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 8D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060468Module · inoperativeMIA - DURING CLIMBOUT UNABLE TO RETRACT LANDING GEAR. RETURNED TO MIA AND LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE FOR REPAIRS. REPLACED LANDING GEAR CONTROL LEVEL MODULE AND PROXIMITY SENSOR ELECTRONICS UNIT. SYSTEM GROUND CHECKED NORMAL OPESDR AALA20060465Solenoid · inoperativeMIA - DURING CLIMB LANDING GEAR WOULD NOT RETRACT. RETURNED TO MIA AND LANDED WITHOUT INCIDENT. REPLACED LEVER LOCK SOLENOID. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050610Battery Pack · inoperativeTUL - EMERGENCY LIGHTS AT SEATS 7F, 13F, 19F, AND AFT RIGHT HAND OVERHEAD AT STATION 967 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT SEATS 7F, 13F, 19F AND AFT RIGHT HAND OVERHEAD AT STATION 967. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to N974AN