N942AN
Service difficulty reports · 210
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 = 'N942AN' 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 = 'N942AN' 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 AALA20120525015Floor Support · corrodedCORROSION AROUND CLIP NUT HOLES ON CABIN FLOOR SUPPORT AT STATION 272 FROM RIGHT BUTTLINES 16 TO 38. INSTALLED NEW FLOORBOARD SUPPORT PER AARD 51-00-05.SDR AALA20120525014Intercostal · crackedINTERCOSTAL CRACKED AT LEFT BUTTLINE 46 FROM STATIONS 312 TO 328. INSTALLED NEW INTERCOSTAL PER SRM 51-10-02 AND AARD 51-00-05-1.SDR AALA20120525013Intercostal · crackedINTERCOSTAL CRACKED AT RIGHT BUTTLINE 25, FORWARD CLIP NUT HOLE BETWEEN STATIONS 312 AND 328 FLOORBEAMS. INSTALLED NEW INTERCOSTAL PER AARD 51-00-05.SDR AALA20120525012Stiffener · crackedVERTICLE STIFFENER ON AFT SIDE VAPOR BARRIER WEB JUST OUTBOARD OF A/C EXHAUST DUCT CUTOUT (LEFT BUTTLINE 25) IS CRACKED AT LOWER END IN THE RADIUS. REMOVED AND REPLACED VERTICLE STIFFENER PER AARD 51-00-05-1 AND BOEING DRAWING NUMBERS 111A1000 SHEET 101 REVISSDR AALA20120525011Stiffener · crackedHORIZONTAL STIFFENER ON FORWARD SIDE OF VAPOR BARRIER WEB IS CRACKED AT INBOARD END FASTENERS CONNECTING IT TO KEEL BEAM. REMOVED AND REPLACED VAPOR BARRIER WEB HORIZONTAL STIFFENER PER AARD 51-00-05-1 AND BOEING DRAWING 111A1000 SHEET 101 REVISION B.SDR AALA20120524005Angle · corrodedFOUND EXCESSIVE CORROSION ON RIGHT NUMBER 1 DOOR CREASE ANGLE. REMOVED AND REPLACED RIGHT NUMBER 1 DOOR CREASE ANGLE PER AARD 51-00-05-1.SDR AALA20120522023Frame · crackedSTATION 727B LEFT FRAME CRACKED AT BIN ATTACH BRACKET FAST HOLE. INSTALLED DOUBLER REPAIR PER ECO J1159AD CARD 0006.SDR AALA20120522022Frame · crackedSTATION 400 LEFT FRAME CRACKED AT BIN ATTACH BRACKET FAST HOLE. INSTALLED DOUBLER REPAIR PER ECO J1159AD CARD 0006.SDR AALA20120522019Frame · crackedSTATION 887 LEFT FRAME CRACKED AT BIN ATTACH BRACKET HOLE. INSTALLED DOUBLER REPAIR PER ECO J1159AD CARD 0007.SDR AALA20120522018Frame · crackedFRAME CRACKED AT FASTENER FOR AIR CONDITIONER BRACKET AT STATION 500A LEFT. REMOVED DAMAGE AND INSTALLED DOUBLER REPAIR PER ECO J1159AD CARD 7.SDR AALA20120522017Frame · crackedFRAME CRACKED AT FASTENER FOR AIR CONDITIONER DUCT BRACKET AT STATION 500D LEFT. REMOVED DAMAGE AND INSTALLED DOUBLER REPAIR PER ECO J1159AD CARD 7.SDR AALA20120522016Frame · crackedSTATION 727B RIGHT FRAME CRACKED AT BIN ATTACH BRACKET HOLE. INSTALLED DOUBLER REPAIR PER ECO J1159AD CARD 0007.SDR AALA20120522015Frame · crackedFRAME CRACKED AT FASTENER FOR AIR CONDITIONING DUCT BRACKET AT STATION 827 R. REMOVED DAMAGE AND INSTALLED DOUBLER REPAIR PER ECO J1159AD CARD 7.SDR AALA20120522014Frame · crackedSTATION 440 LEFT FRAME CRACKED AT BIN ATTACH BRACKET HOLE. INSTALLED DOUBLER PER ECO J1159AD CARD 0007.SDR AALA20120522013Frame · crackedFRAME CRACKED AT FASTENER FOR AIR CONDITIONING DUCT BRACKET AT STATION 380L. REMOVED DAMAGE AND INSTALLED DOUBLER REPAIR PER ECO J1159AD CARD 7.SDR AALA20120522012Frame · crackedSTATION 500A RIGHT FRAME CRACKED AT BIN ATTACH BRACKET HOLE. INSTALLED DOUBLER REPAIR PER ECO J1159AD CARD 0007.SDR AALA20120522010Frame · crackedSTATION 480 RIGHT FRAME CRACKED AT BIN ATTACH FASTENER HOLE. INSTALLED DOUBLER REPAIR PER ECO J1159AD CARD 0007.SDR AALA20120522009Frame · crackedSTATION 440 RIGHT FRAME CRACKED AT BIN ATTACH FASTENER HOLE. INSTALLED DOUBLER REPAIR PER ECO J1159AD CARD 0007.SDR AALA20120522007Frame · crackedSTATION 400 RIGHT FRAME CRACKED AT BIN BRACKET ATTACH HOLE. INSTALLED DOUBLER PER ECO J1159AD CARD 0007.SDR AALA20120521021Skin · damagedFORWARD CARGO DOOR SKIN HAS DENTS AND DEEP MARKS. REMOVED AND REPLACED FORWARD CARGO DOOR OUTER SKIN PER ESO 60654.SDR AALA20120521006Intercostal · crackedFLOOR SUPPORT INTERCOSTAL CRACKED AT CLIP NUT HOLE LEFT BUTTLINE 45, BETWEEN STATIONS 312 AND 328. INSTALL NEW INTERCOSTAL PER SRM 51-10-02 AND AARD 51-00-05-1.SDR AALA20120521005Intercostal · crackedFLOOR SUPPORT INTERCOSTAL CRACKED AT CLIP NUT HOLE AT LEFT BUTTLINE 45, BETWEEN STATIONS 328 AND 344. INSTALL NEW INTERCOSTAL PER SRM 51-10-02 AND AARD 51-00-05-1.SDR AALA20120521004Intercostal · crackedE/E INTERCOSTAL CRACKED AT LEFT BUTTLINE 46 BETWEEN STATIONS 328 TO 344. INSTALLED NEW INTERCOSTAL PER SRM 51-10-02 AND AARD 51-00-05-1.SDR AALA20120518009Skin · dentedDENT ON EMERGENCY EQUIPMENT DOOR EXTERNAL SKIN. NEW OUTER SKIN FABRICATED AND INSTALLED PER ESO 60381 PAGE 602A.SDR AALA20120530019Transition Panel · corrodedCORROSION ON SIDEWALL OF TRANSITION PANEL. INSTALLED NEW TRANSITION PANEL FROM STATIONS 420 TO 480 PER AARD 51-00-5.SDR AALA20120331008Sensor · inoperativeCREW REPORTED LEADING EDGE TRANSIT LIGHT FLICKERING IN FLIGHT. EMERGENCY DECLARED FLIGHT LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND NR 1 SLAT SENSOR FAULTING. REPLACED SENCOR S169. SYSTEM GROUND CHECKED NORMAL.SDR AALA20101018TUL16Oven · malfunctionedMIA - FLIGHT ATTENDANT REPORTED HEAVY SMOKE COMING FROM THE NUMBER 1 OVEN. FLIGHT ATTENDANT PULLED THE OVEN"S CIRCUIT BREAKER AND HALON EXTINGUISHER WAS DISCHARGED INTO OVEN AND SMOKE DISSIPATED. FLIGHT LANDED MIA WITHOUT INCIDENT. REPLACED NUMBER ONE OVEN.SDR AALA20100608DFW13Light · inoperativeONE LAMP INOPERATIVE IN THE EMERGENCY FLOOD LIGHT ABOVE THE LEFT NUMBER 1 PASS DOOR. REPLACED LAMP ONE POSITION IN THE EMERGENCY FLOOD LIGHT ABOVE THE LEFT NUMBER 1 PASS DOOR. OPS CHECKED NORMAL.SDR AALA20100608DFW12Light · inoperativeTHE RIGHT AISLE BULLNOSE EMERGENCY FLOOD LIGHT AT ROW 5 IS INOPERATIVE. REPLACED LAMP FOR THE RIGHT AISLE BULLNOSE EMERGENCY FLOOD LIGHT AT ROW 5. OPS CHECKED NORMAL.SDR AALA20100608DFW11Light · inoperativeTHE AFT EMERGENCY HATCH HANDLE FLOOD LIGHT FOR THE LEFT FORWARD OVERWING EXIT HATCH IS INOPERATIVE. REPLACED LAMP AT THE AFT EMERGENCY HATCH HANDLE FLOOD LIGHT FOR THE LEFT FORWARD OVERWING EXIT HATCH. OPS CHECKED NORMAL.SDR AALA20100608DFW10Shroud · crackedTHE ESCAPE PATH LIGHTING SHROUD AT 28D IS CRACKED. REPLACED THE ESCAPE PATH LIGHTING SHROUD AT 28D. OPS CHECKED NORMAL.SDR AALA20100608DFW09Shroud · crackedTHE ESCAPE PATH LIGHTING SHROUD AT 22D IS CRACKED. REPLACED THE ESCAPE PATH LIGHTING SHROUD AT 22D. OPS CHECKED NORMAL.SDR AALA20100608DFW08Shroud · crackedTHE ESCAPE PATH LIGHTING SHROUD AT 19D IS CRACKED. REPLACED THE ESCAPE PATH LIGHTING SHROUD AT 19D. OPS CHECKED NORMAL.SDR AALA20100608DFW07Shroud · crackedTHE ESCAPE PATH LIGHTING SHROUD AT 17D IS CRACKED. REPLACED THE ESCAPE PATH LIGHTING SHROUD AT 17D. OPS CHECKED NORMAL.SDR AALA20100608DFW06Shroud · crackedTHE ESCAPE PATH LIGHTING SHROUD AT 15D IS CRACKED. REPLACED THE ESCAPE PATH LIGHTING SHROUD AT 15D. OPS CHECKED NORMAL.SDR AALA20100608DFW05Shroud · crackedTHE AFT ESCAPE PATH LIGHTING SHROUD AT 13D IS CRACKED. REPLACED THE AFT ESCAPE PATH LIGHTING SHROUD AT 13D. OPS CHECKED NORMAL.SDR AALA20100608DFW04Shroud · crackedTHE AFT ESCAPE PATH LIGHTING SHROUD AT 12D IS CRACKED. REPLACED THE AFT ESCAPE PATH LIGHTING SHROUD AT 12D. OPS CHECKED NORMAL.SDR AALA20100608DFW03Shroud · crackedTHE ESCAPE PATH LIGHTING SHROUD AT 11D IS CRACKED. REPLACED THE ESCAPE PATH LIGHTING SHROUD AT 11D. OPS CHECKED NORMAL.SDR AALA20100608DFW02Shroud · crackedTHE AFT ESCAPE PATH LIGHTING SHROUD AT 7D IS CRACKED. REPLACED THE AFT ESCAPE PATH LIGHTING SHROUD AT 7D. OPS CHECKED NORMAL.SDR AALA20100407TUL21Clamp · looseIAD - CREW REPORTED ON CLIMBOUT RIGHT WING TO BODY OVERHEAT DETECTION INDICATION ILLUMINATED. EMERGENCY DECLARED RETURNED IAD LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND LOOSE DUCT CLAMP TO RIGHT WING ANTI-ICE DUCT NEAR KRUEGER FLAP AND TESDR AALA20090814TUL21Skin · dentedFUSELAGE SKIN DENTED WITH GOUGE AT STATION 268 AT STRINGER 5 LEFT. INSTALLED EXTERNAL DOUBLER UNDER SRM 53-00-01-02 AND EA B737-53-007125.SDR AALA20090814TUL20Skin · dentedFUSELAGE SKIN DENTED AT STATION 320 STRINGER 3L. INSTALLED REPAIR DOUBLER UNDER SRM 53-00-01 2R.SDR AALA2009050400870Light · inoperativeMIA EXTERIOR OVERWING EMERGENCY LIGHTS INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EXTERIOR OVERWING EMERGENCY LIGHTS.SDR AALA2009032700003Oil Cooler · inoperativeMIA - AUXILIARY POWER UNIT LOW OIL PRESSURE INDICATION WITH LEFT ENGINE GENERATOR ON PLACARD. RETURNED MIA WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED AUXILIARY POWER UNIT OIL COOLER AND NUMBER ONE INTEGRATED DRIVE GENERATOR. SYSTEM GROUND CHSDR AALA20072584Battery Pack · failedTUL - EMERGENCY LIGHT BATTERY PACK FOR RIGHT MID TO AFT CABIN FAILED TEST. REPLACED BATTERY PACK AT STATION 727 FOR EMERGENCY LIGHTS IN RIGHT HAND MID TO AFT CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072583Battery Pack · failedTUL - EMERGENCY LIGHT BATTERY PACK AT RIGHT FORWARD WING EXIT DOOR FAILED TEST. REPLACED BATTERY PACK AT STATION 565 FOR EMERGENCY LIGHTS AT RIGHT FORWARD WING EXIT DOOR CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072064Lamp · inoperativeDFW - EMERGENCY LIGHT AT LEFT LOWER EXTERIOR INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT LEFT LOWER EXTERIOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071269Apu · failedLGA - ON GROUND T1084/08JUL - AS PASSENGERS WERE DEPLANING WHEN LIGHTS FLICKERED AND WARNING LIGHTS WENT OFF IN COCKPIT. A FLIGHT ATTENDANT REPORTED SMELLING AN ODOR AND SEEING SMOKE OUTSIDE THE AFT RIGHT GALLEY DOOR. DISCHARGED FIRE BOTTLE. EVACUATED REMAISDR AALA20070222Controller · inoperativeMSY INFLIGHT T2036/29JAN DFW TO MIA - CAPTAINS LEFT NUMBER TWO SLIDING WINDOW BEGAIN ARCING AND WINDOW CRACKED. LANDED MSY WITHOUT INCIDENT. REPLACED LEFT NUMBER TWO WINDOW AND HEAT CONTROLLER. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061004Connector · disconnectedDFW - EMERGENCY PROXIMITY FLOOD LIGHT AT AFT RIGHT GALLEY INOPERATIVE. FOUND PLUG D12920 DISCONNECTED FROM AFT GALLEY OVERHEAD. RECONNECTED PLUG L1420 FOR EMERGENCY PROXIMITY FLOOD LIGHT AT AFT RIGHT GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to N942AN