N922AN
Service difficulty reports · 202
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 = 'N922AN' 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 = 'N922AN' 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 AALA20161026012Lens · unsecureAIRCRAFT NOT GROUNDED. FORWARD GALLEY SERVICE DOOR EMERGENCY EXIT LIGHT LENS COVER WILL NOT STAY ON. REMOVED AND REPLACED EXIT LIGHT ASSEMBLY IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20160925002O-Ring · leakingDURING DESCENT, SYSTEM A HYDRAULIC QUANTITY REDUCED TO 8%. LEFT ENGINE HYDRAULIC PUMP LOW PRESSURE LIGHT ILLUMINATED. EMERGENCY DECLARED. LANDING UNEVENTFUL. AIRCRAFT WAS GROUNDED. MAINTNENANCE FOUND A SYSTEM ELECTRIC MOTOR DRIVEN PUMP ACOUSTIC FILTER PRESDR AALA20160725004Skin · crackedRIGHT HORIZONTAL STABILIZER LOWER SKIN IS CRACKED AT HSS 138.70. REPAIRED SKIN IAW SRM 55-10-01-2R-11.SDR AALA20150911014Transmitter · faultyEMERGENCY DECLARED, LANDING UNEVENTFUL & ACFT NOT OVERWEIGHT. DURING APPROACH, FLAP LOCK OUT REPORTED. R & R NR 1 FLAP TRANSMITTER IAW AMM 27-58-01.SDR AALA20150825010Fseu · faultyEMERGENCY DECLARED, LANDING UNEVENTFUL & ACFT NOT OVERWEIGHT. DURING APPROACH THE TE FLAPS STUCK AT 25 DEGREES. AFTER LANDING FLAPS RETURNED TO 15 DEGREES AGREEING WITH FLAP HANDLE SETTING. TROUBLESHOOTING FOUND FAULT 27-53280. ACCOMPLISHED FIM 27-51-00-81SDR AALA20150818024Unknown · malfunctionedEMERGENCY DECLARED, LANDING UNEVENTFUL & ACFT NOT OVERWEIGHT. DURING APPROACH FLAPS WERE SELECTED TO 15 BUT ONLY EXTENDED TO 5 & REMAINED AT 5 WHEN SELECTED TO 30. PERFORMED INSPECTION OF FLAPS. ACCOMPLISHED FIM 27-51-00 WITH NO FAULTS NOTED.SDR AALA20150709004Light · damagedEMERGENCY LIGHT ASSEMBLY AT FWD SERVICE DOOR IS DAMAGED. R & R LIGHT ASSEMBLY & PERFORMED OPERATIONAL CHECK IAW AMM 33-51-01.SDR AALA20150705001Wire Harness · faultyAFTER THRUST PUSHED UP FOR TAKEOFF NR 1 ELEC ENG CONTROL LIGHT ILLUMINATED. TAKEOFF ABORTED AT LOW SPEED. R & R HARNESS HAR 5423 IAW AMM 73-21-06-400-802-F00. ACCOMPLISHED TEST AS REQUIRED WITH NO FAULTS NOTED.SDR AALA20150417015Transceiver · faultyBOTH VHF COMMS INOPERATIVE AFTER TAKEOFF. TOWER REPORTS THEY WERE ABLE TO HEAR THE ACFT BUT CREW REPORTS THEY WERE UNABLE TO HEAR TOWER. EMERGENCY DECLARED AND RETURNED TO DEPARTURE. LANDING UNEVENTFUL. R & R NR 1 VHF TRANSCEIVER & ACCOMPLISHED INSTALLATIOSDR AALA20140828003Trunnion · corrodedFOUND CUT SEALANT AROUND TRUNNION FUSE BOLTS. INVESTIGATION FOUND CORROSION ON TRUNNION LUGS FWD INBD. ACCOMPLISHED CORROSION REMOVAL & REPAIR IAW SRM 57-20-90-2R-3 & EA B737-57-035899.SDR AALA20140728003Trunnion · corrodedFOUND CUT SEALANT AROUND TRUNNION FUSE BOLTS. INVESTIGATION FOUND CORROSION ON TRUNNION LUGS FWD INBD. ACCOMPLISHED CORROSION REMOVAL & REPAIR IAW SRM 57-20-90-2R-3 & EA B737-57-035899.SDR AALA20140728011Skin · corrodedCORROSION WAS DISCOVERED ON THE LT LOWER WING SKIN BENEATH THE DRAG LINK ASSEMBLY. REMOVED CORROSION & INSTALLED A SHIM IAW EA B737-57-035801.SDR AALA20140101002Transmitter · faultyJFK CREW REPORTED FLAP DISAGREE ON APPROACH. EMERGENCY DECLARED FLIGHT LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED NR 8 FLAP POSITION TRANSMITTER. SYSTEM GND CHECKED NORMAL OPERATION CLOSED.SDR AALA20131009001Check Valve · inoperativeLAX CREW REPORTED NR 2 ENG HYD PUMP LOW PRESSURE LIGHT ILLUMINATED. EMERGENCY DECLARED FLIGHT RETURNED LAX LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED ENG DRIVEN PUMP THAT HAD SEIZED & RT HAND CASE DRAIN CHECK VALVE. SYSTEM GROUND CHESDR AALA20131007009Pump · failedLAX NR 2 HYD LOW PRESSURE ENG LIGHT ILLUMINATED THEN ENG NR 2 HYD SYSTEM FLUID QUANTITY EMPTY. EMERGENCY DECLARED FLIGHT LANDED LAX WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED RT ENG DRIVEN PUMP. SYSTEM GROUND CHECKED NORMAL OPERATION CLOSED.SDR AALA20130926010Light · inoperativeEMERGENCY LIGHT ON OVERHEAD STOW BINS AT ROW 20R INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT ON OVERHEAD STOW BINS AT ROW 20R. OPERATIONS CHECKED NORMAL.SDR AALA20130916004Fuse · defectiveEMERGENCY LIGHT ON OVERHEAD STOW BINS AT ROW 21L INOPERATIVE. REPLACED FUSE AT EMERGENCY BATTERY PACK M1670. OPERATIONS CHECKED NORMAL.SDR AALA20130619009Light · damagedFIRST CLASS EMERGENCY LIGHT DAMAGED. REPLACED LIGHT ASSEMBLY FOR FIRST CLASS EMERGENCY AISLE LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130619008Light · damagedFIRST CLASS EMERGENCY LIGHT DAMAGED. REPLACED LIGHT ASSEMBLY FOR FIRST CLASS EMERGENCY LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20120724020Intercostal · crackedEMERGENCY EQUIPMENT COMPARTMENT INTERCOSTAL CRACKED FROM STATIONS 344 TO 360 LEFT BUTTLINE 10. REPLACED INTERCOSTAL PER AARD 51-40-02.SDR AALA20120724019Intercostal · crackedEMERGENCY EQUIPMENT COMPARTMENT INTERCOSTAL CRACKED FROM STATIONS 344 TO 360 BUTTLINE 0. REPLACED INTERCOSTAL PER AARD 51-40-02.SDR AALA20100815TUL03Blower · seizedTUL - INFLIGHT LAS-MIA. CREW REPORTED WEATHER RADAR FAILED. DIVERTED TUL LANDED WITHOUT INCIDENT. REPLACED WEATHER RADAR RIGHT BLOWER. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20100619TUL02Oil System · overservicedCUN - INFLIGHT MIA-GUA. CREW REPORTED FUMES IN AFT CABIN GALLEY AREA. EMERGENCY DECLARED DIVERTED CUN LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. BOTH ENGINE OIL LEVELS WERE OVERSERVICED. DRAINED OIL TO NORMAL LEVELS. SYSTEM GROUND CHECK NORMSDR AALA20100507TUL02Floor Support · corrodedCORROSION ON AFT CABIN FLOOR AREA LEFT BUTTLINE 18 JUST FORWARD OF AFT BULKHEAD ON FLOORBOARD SUPPORT. ACCOMPLISHED DOUBLER REPAIR.SDR AALA20100507TUL21Intercostal · corrodedTHE INTERCOSTAL AT RIGHT BUTTLINE 11 AND STATIONS 312 TO 328 IS CORRODED. REPLACED THE INTERCOSTAL PER SRM 51-10-02.SDR AALA20100507TUL17Fitting · crackedIN THE FORWARD CARGO THE FRAME TO INTERCOSTAL CLIP IS CRACKED AT STRINGER 25 LEFT TATION 500H. REPLACED THE CLIP PER SRM 51-10-02.SDR AALA20100504TUL13Skin · crackedRIGHT HORIZONTAL STAB LEADING EDGE SECTION HAS BEEN BLEND AND POSSIBLE CRACK 79 INCHES FROM INBOARD END MARKED. CUT AWAY DAMAGED AREA AND INSTALLED FLUSH REPAIR RIGHT HORIZONTAL LEADING EDGE 79 INCHES FROM INBOARD END PER SRM 55-10-01-2R.SDR AALA20100507TUL05Angle · corrodedIN THE AFT CARGO THE LEFT "Z" ANGLE HAS AREAS OF CORROSION STATIONS 787 TO 807. INSTALLED REPAIR SECTION AND SPLICES PER SRM 53-00-53-2R5 AND SRM 53-00-53-2R6.SDR AALA20100504TUL10Frame · crackedTHE LEFT FRAME IS CRACKED AT STATION 400 AT AIR CONDITION RAIL BRACKET INBOARD HOLE. REPAIRED PER ECO J1159AC.SDR AALA20100504TUL07Intercostal · crackedAT STATION 277 TO 294 INTERCOSTAL CRACKED AT FLOORBOARD FASTENER HOLES. REPLACED THE INTERCOSTAL PER SRM 51-10-02-0G.SDR AALA20100506TUL23Frame · crackedTHE FRAME AT STATION 480 RIGHT IS CRACKED AT AIR CONDITION RAIL BRACKET INBOARD HOLE. REPAIRED PER J1159AC CARD 0005 NON ROUTINE 1340796 IN DWMS.SDR AALA20100505TUL10Frame · crackedTHE RIGHT FRAME AT STATION 480 AT AIR CONDITION RAIL BRACKET INBOARD HOLE IS CRACKED. REPAIRED PER ECO J1159AC CARD 0005.SDR AALA20100505TUL09Frame · crackedTHE RIGHT FRAME AT STATION 400 IS CRACKED AT AIR CONDITION RAIL BRACKET INBOARD HOLE. REPAIRED PER J1159AC CARD 0005.SDR AALA20100505TUL07Frame · crackedTHE RIGHT FRAME AT STATION 727 IS CRACKED AT AIR CONDITION RAIL BRACKET INBOARD HOLE. REPAIRED PER J1159AC CARD 0005.SDR AALA20100504TUL11Frame · crackedSTATION 500C RIGHT FRAME CRACKED AT AIR CONDITIONING RAIL BRACKET INBOARD HOLE. REPAIRED PER TASK CARD J1159_0005-/002.SDR AALA20100503TUL15Intercostal · crackedTHE INTERCOSTAL AT LEFT BUTTLINE 45 AND STATIONS 328 TO 344 IS CRACKED. REPLACED THE INTERCOSTAL.SDR AALA20100503TUL07Frame · crackedTHE RIGHT FUSELAGE FRAME IS CRACKED AT AIR CONDITION RAIL BRACKET INBOARD HOLE AT STATION 500C REPAIRED PER ENGINEERING CHANGE ORDER J1159AC.SDR AALA20100507TUL18Fitting · crackedBAFFLE CLIP CRACKED STATION 500H STRINGER 25 LEFT. REPLACED CLIP PER SRM 51-10-2.SDR AALA20100512TUL03Stiffener · corrodedCORROSION IN AUXILIARY POWER UNIT COMPARTMENT ON AFT FLANGE OF APU INLET PLENUM, LOWER 6 INCHES OF FLANGE, 3 SEPARATE AREAS. REPLACED AFT STIFFENER STATION 1125 PER SRM 51-10-02-0G PARAGRAPH 8SDR AALA20100430TUL11Fitting · crackedFRAME TO INTERCOSTAL CLIP CRACKED STATION 500G STRINGER 25 LEFT. REPLACED CLIP PER SRM 51-10-2.SDR AALA20100430TUL10Fitting · crackedFRAME TO INTERCOSTAL CLIP CRACKED AT STRINGER STATION 500G. REPLACED CLIP PER SRM 51-10-2.SDR AALA20100506TUL24Intercostal · crackedINTERCOSTAL CRACKED AT LEFT BUTTLINE 45 BETWEEN STATIONS 312 AND 328. REPLACED ON TASK CARD 1260/004 IN DWMS NON ROUTINE 1340223 PER SRM 53-10-51-01 2.SDR AALA20100517TUL04Vapor Barrier · crackedLEFT AIR CONDITIONING BAY, AFT VAPOR BARRIER CRACKED (HAS INTERIM REPAIR). INSTALLED REPAIR STRAPS AND ANGLES ON BAYS 1L, 2L AND 4L PER AARD 57-10-10-8R.SDR AALA20100514TUL01Stiffener · crackedLEFT AIR CONDITIONING BAY AFT VAPOR BARRIER HORIZONTAL STIFFENER CRACKED AT INBOARD END. INSTALLED HORIZONTAL STIFFENER LEFT AIR CONDITIONING BAY PER SRM 51-10-2.SDR AALA20100506TUL07Stringer Clip · crackedSTRINGER CLIP CRACKED STATION 500H AT STRINGER 25 LEFT. INSTALLED NEW STRINGER CLIP PER SRM 51-10-2.SDR AALA200801438Lamp · inoperativeLGA - EMERGENCY LIGHT AT SEAT ROW 25ABC INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT ROW 25ABC. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801437Lamp · inoperativeLGA - EMERGENCY LIGHT AT SEAT ROW 20ABC INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT ROW 20ABC. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA20070159Module · inoperativeATL INFLIGHT - GEAR WOULD NOT RETRACT AFTER TAKEOFF. FOLLOWED PROCEDURE AND RAISED GEAR. ALL SYSTEMS NORMAL AFTER GEAR RETRACTED. LANDED ATL WITHOUT INCIDENT. REPLACED LANDING GEAR CONTROL PANEL. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060672Valve · malfunctionedSTL - YUL TO DFW - RIGHT WING FUEL IMBALANCE OF 500 POUNDS PER .5 HOUR DURING FLIGHT. LANDED STL WITHOUT INCIDENT. REPLACED FUEL FEED CROSSFEED VALVE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050594Battery Pack · inoperativeTUL EMERGENCY LIGHTS IN CABIN FAILED FUNCTIONAL CHECK. REPLACED BATTERY PACKS AT M1674 AND M1675 FOR EMERGENCY LIGHTS IN CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to N922AN