N948AN
Service difficulty reports · 189
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 = 'N948AN' 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 = 'N948AN' 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 AALA201807176002Floorbeam · corrodedCORROSION ON THE TOP OF THE FLOORBEAM AT BS 986, RBL 43. REPLACED THE FLOORBEAM IAW SRM 51-20-01.SDR AALA201803059037Bypass Valve · faultyFLAPS ASSYMETRICAL AT 1 DEGREE, OCCURED AFTER TAKEOFF ON FLAP RETRACTION, FROM 1 DEGREE AND HAD TAKE OFF CONFIGURATION ALERT JUST AFTER ROTATION WITH JUST TWO ALERTS. EMERGENCY DECLARED, LANDED WITHOUT FURTHER INCIDENT. MAINTENANCE REPLACED THE FLAP TRANSMISDR AALA20180302007Transmitter · faultyFLAPS ASSYMETRICAL AT 1 DEGREE, OCCURED AFTER TAKEOFF ON FLAP RETRACTION, FROM 1 DEGREE AND HAD TAKE OFF CONFIGURATION ALERT JUST AFTER ROTATION WITH JUST TWO ALERTS. EMERGENCY DECLARED, LANDED WITHOUT FURTHER INCIDENT. MAINTENANCE REPLACED THE FLAP TRANSMISDR AALA20171219004Bushing · damagedAFTER TAKEOFF 1000 FLAP ASYMMETRY LEFT AND RIGHT FLAP SPLIT AT 1-3 AND LEADING EDGE PANEL ANNUNCIATOR SHOWED NO LIGHTS RETRACT FOR LDG, FLAP HANDLE IN 1 DEGREE POSITION. REPLACED THE NR 8 FLAP JACKSCREW GIMBAL BUSHING ASSEMBLY, INSTALLED A NEW BOLT AND COLLSDR AALA20171119005Flap System · stuckTRAILING EDGE FLAPS STUCK IN DOWN POSITION. EMERGENCY DECLARED, AND FLIGHT RETURNED TO DEPARTURE. LANDING UNEVENTFUL. ACCOMPLISHED FLAP SLAT ELECTRONICS UNIT BITE CHECK AND FOUND CODE 27-53252, FLAP 3 SKEW FAULT. ACCOMPLISHED FIM 27-59-00. NO ABNORMALITISDR AALA20170209005Lens · brokenEMERGENCY EXIT PROXIMITY FLOODLIGHT ON THE FORWARD GALLEY WALL HAS A BROKEN LENS COVER. REMOVED AND REPLACED THE FLOODLIGHT ASSEMBLY IAW AMM 33-51-14. OPS CHECKED GOOD.SDR AALA20161107039Bracket · dirtyAIRCRAFT NOT GROUNDED. R1 DOOR EMERGENCY SLIDE GIRT BAR DIFFICULT TO ARM/DISARM. CLEANED GIRT BAR BRACKETS IAW GPM. OPERATIONAL CHECK GOOD.SDR AALA20161029002Beam · wornTHE CENTER WING SUPPORT BEAM IS WORN AT THE RIGHT AIR CONDITIONING BAY PNEUMATIC ACCESS DOOR LATCH LANDINGS. REPAIRED THE BEAM IAW EA 264817.SDR AALA20160515001Light · crackedAIRCRAFT WAS NOT GNDED. EMER EXIT LIGHT AT G2 GALLEY IS CRACKED. R & R LIGHT ASSEMBLY.SDR AALA20151102004Seat Track · crackedCRACK INDICATIONS FOUND AT STATION 727B, RBL 45.50, INBD & OTBD SEAT TRACK FASTENER HOLES. REPAIRED CRACKS IN SEAT TRACK FLANGE IAW EA 255652.SDR AALA20151102003Seat Track · crackedCRACK INDICATIONS FOUND AT STATION 727B, RBL 24.75, INBD & OTBD SEAT TRACK FASTENER HOLES. REPAIRED CRACKS IN SEAT TRACK FLANGE IAW EA 255652.SDR AALA20151102002Seat Track · crackedCRACK INDICATIONS FOUND AT STATION 727B, LBL 45.50, INBD & OTBD SEAT TRACK FASTENER HOLES. REPAIRED CRACKS IN SEAT TRACK IAW EA 255652.SDR AALA20151102001Seat Track · crackedCRACK INDICATIONS FOUND AT STATION 727B, LBL. 24.75, INBD SEAT TRACK HOLES. REPAIRED CRACKS IN SEAT TRACK IAW EA 255652.SDR AALA20151018001Cover · brokenAFT GALLEY DOOR EXIT SIGN COVER BOTH DOORS FALLEN OFF IN COCKPIT. REPLACED BOTH GALLEY DOOR EXIT SIGN COVER ASSEMBLIES AFT IAW 33-51-01.SDR AALA20151006008Skin · crackedRIGHT HORIZONTAL STABILIZER, LOWER SKIN CRACKED AT HORIZONTAL STABILIZER STATION 138.70, 26" & 34" AFT OF SKIN LE. INSTALLED REPAIR DOUBLER IAW SRM 55-10-01-2R-11 & EA 255059.SDR AALA20150525007Indication Sys · faultyAIR INTERRUPT, EMER DECLARED, LANDING UNEVENTFUL & ACFT NOT OVERWEIGHT. DURING CRUISE, CREW NOTED A RT TANK FUEL QTY LOSS INDICATION IN FLIGHT. PERFORMED VISUAL INSPECTION OF WINGS. FUSELAGE & RT ENG WITH NO LEAKS NOTED. PERFORMED FUEL CROSS FEED VLV CHECKSDR AALA20150402007Lens · missingEXIT LIGHT LENS CAP MISSING NEXT TO FWD SERVICE DOOR. REPLACED LENS CAP FOR LIGHT L1186 IAW MM 33-51-01. OPERATIONS CHECKED OK.SDR AALA20140218004Hydraulic Line · damagedIAD CREW REPORTED INDICATION OF SYS A HYD QUANTITY LOSS. EMERGENCY DECLARED FLIGHT LANDED IAD WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FOUND A HOLE IN THE RT HAND MLG UPLOCK ACTUATOR SUPPLY LINE. REPLACED LINE & SERVICED HYD SYS. SYS GND CHECKED NSDR AALA20130906001Light · inoperativeEXTERIOR RT FWD OVERWING EXIT LIGHT INOPERATIVE. REPLACED LAMP FOR EXTERIOR RT FWD OVERWING EXIT LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130707001Light · brokenFORWARD GALLEY EMERGENCY LIGHT BROKEN & LENS WILL NOT STAY ON. REPLACED FORWARD GALLEY EMERGENCY EXIT LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130428003Lens · missingSEAT 15 EMERGENCY LIGHT CLEAR LENS MISSING. REPLACED EMERGENCY LIGHT CLEAR LENS FOR SEAT 15. OPS CHECK NORMAL.SDR AALA20130226003Lens · damagedLEFT AFT OVERWING ESCAPE HATCH EXIT IDENTIFIER UNREADABLE. REMOVED AND REPLACED LEFT AFT OVERWING ESCAPE HATCH EXIT IDENTIFIER LENS. OPS CHECK NORMAL.SDR AALA20130226002Plate · brokenRIGHT AFT DOOR EMERGENCY LIGHT EXIT IDENTIFIER BASE PLATE BROKEN. REMOVED AND REPLACED LIGHT RIGHT HAND AFT DOOR EMERGENCY LIGHT EXIT IDENTIFIER ASSEMBLY. OPS CHECK NORMAL.SDR AALA20120828017Skin · crackedCRACK ON LOWER SKIN AND BULGE ON UPPER SKIN ALONG TRAILING EDGE 5 INCHES FROM INBOARD END OF FLAP. REMOVED DAMAGE TO UPPER AND LOWER SKINS AND HOT BONDED REPAIR FILLER AND DOUBLER PER SRM 51-70-10.SDR AALA20120802010Floorbeam · corrodedSTATION 328 FLOORBEAM CORRODED AT RIGHT BUTTLINE 22. ACCOMPLISHED NESTED ANGLE REPAIR PER SRM 53-10-51-2R.SDR AALA20120802009Floorbeam · corrodedSTATION 328 FLOORBEAM CORRODED AT RIGHT BUTTLINE 15. ACCOMPLISHED NESTED ANGLE REPAIR PER SRM 53-10-51-2R.SDR AALA20120801005Floorbeam · corrodedCORROSION ON FLOORBEAM AT STATION 986 RIGHT TO LEFT BUTTLINE 64. REPLACED T-CHORD PER SRM 53-70-51-2R 4.SDR AALA20120731007Strip · corrodedCORROSION ON TRANSITION STRIP BETWEEN STATIONS 767 TO 794. REPLACED TRANSITION STRIP PER AARD 51-00-05-1, SRM 51-40-02, DRAWING 146A8127 AND 146A0081 AND EA B737-53-025315.SDR AALA20120730008Intercostal · crackedINTERCOSTAL FROM STATIONS 344 TO 360 AT LEFT BUTTLINE 11 CRACKED. REPLACED INTERCOSTAL PER AARD 51-10-05-1.SDR AALA20120725014Angle · corrodedFORWARD SERVICE DOOR CUTOUT CREASE ANGLE CORRODED AT STATION 330. CREASE ANGLE REPLACED PER EA B737-53-025208.SDR AALA20120725008Angle · corrodedCORROSION SEVERAL PLACES ON LEFT TRANSITION Z ANGLE FROM STATIONS 795 TO 847. INSTALLED Z CHANNEL PER SRM 53-00-53-2R-5.SDR AALA20120725004Angle · corrodedCORROSION ON RIGHT TRANSITION Z ANGLE BETWEEN STATIONS 727J AND 767. INSTALLED NESTED ANGLE REPAIR PER 53-00-53-2R5 AND EA B737-53-025066.SDR AALA20120724002Frame · crackedFRAME CRACKED AT AIR CONDITIONING RAIL ATTACH BRACKET INBOARD FASTENER, STATION 500A RIGHT. REMOVED DAMAGE AND INSTALLED DOUBLER REPAIR PER ECO J1159 CARD 7.SDR AALA20120728007Floor Support · corrodedCORROSION ON AFT CARGO FLOOR SUPPORT TRACK AT STATION 793, LEFT BUTTLINE 17. INSTALLED REPAIR STRAPS PER THE EA B737-53-025285.SDR AALA20120810006Web · corrodedCORROSION ON WEB AUXILIARY POWER UNIT COMPARTMENT, RIGHT SIDE, AT STATIONS 1125 TO 1128. INSTALLED DOUBLER REPAIR PER EA B737-53-025480.SDR AALA20120719008Frame · crackedFRAME CRACKED AT AIR CONDITIONING RAIL BRACKET, STATION 440 LEFT SIDE. INSTALLED REPAIR ANGLE PER ECO J1159 CARD 0006.SDR AALA20120719007Frame · crackedFRAME CRACKED AT AIR CONDITIONING RAIL BRACKET, STATION 400 LEFT SIDE. INSTALLED REPAIR ANGLE PER ECO J1159 CARD 0006.SDR AALA20120719005Skin · gougedGOUGE UNDER INTERIM REPAIR BETWEEN STINGER 19 TO 21 LEFT, BETWEEN STATIONS 500A AND 500B. INSTALLED REPAIR DOUBLER PER WITH EA B737-53-025064.SDR AALA20120718009Frame · crackedCRACK IN FRAME AT AIR CONDITIONING RAIL MOUNT BRACKET, STATION 727B RIGHT. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159 CARD 7.SDR AALA20120718003Rail · crackedAIR CONDITIONING RAIL AT STATION 440 RIGHT CRACKED. ACCOMPLISHED NESTED ANGLE REPAIR PER ESO 1159AD CARD 7.SDR AALA20120727010Cargo Track · corrodedCORROSION ON CARGO FLOOR SUPPORT TRACK AT RIGHT BUTTLINE 17 BETWEEN STATIONS 787 AND 832. INSTALLED NEW CARGO TRACK SECTION PER SRM 53-00-53-2R REPAIR 3.SDR AALA20120720006Frame · crackedFRAME CRACKED AT AIR CONDITIONING RAIL BRACKET, STATION 480 LEFT SIDE. INSTALLED BELL FRAME REPAIR PER AD J1159 CARD 0006.SDR AALA20120724008Intercostal · corrodedCORROSION ON INTERCOSTAL BETWEEN STATIONS 767 AND 787, APPROXIMATELY 2 INCHES BELOW STRINGER 25 RIGHT. INSTALLED WEB PER AARD 51-00-05-1, SRM 51-40-02, DRAWINGS 146A8123 AND 146A0081.SDR AALA20120727009Sill · corrodedCORROSION ON AFT CARGO DOOR CUTOUT LOWER SILL WEB ON UPPER AND LOWER SURFACES SEVERAL AREAS BETWEEN STATIONS 796 AND 847. INSTALLED NEW DOOR SILL WEB PER AARD 51-10-05 AND BOEING DRAWING 146A8340.SDR AALA20120724010Frame · crackedFRAME CRACKED AT AIR CONDITIONING RAIL ATTACH BRACKET INBOARD FASTENER, STATION 867 RIGHT. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AD-0007.SDR AALA20120724006Angle · corrodedCORROSION ON RIGHT TRANSITION Z ANGLE, BETWEEN STATIONS 727J AND 767. REPLACED ANGLE PER SRM 51-10-2 AND SRM 53-00-53-1A2.SDR AALA20120721004Frame · crackedFRAME CRACKED AT AIR CONDITIONING RAIL BRACKET, STATION 500A LEFT SIDE. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AD.SDR AALA20120720005Frame · crackedFRAME CRACKED AT AIR CONDITIONING RAIL BRACKET, STATION 440 LEFT SIDE. INSTALLED BELL FRAME REPAIR PER AD J1159 AD CARD 0006.SDR AALA20120717008Web · corrodedWEB FROM STATIONS 440 TO 500 CORRODED. REPLACED WEB FROM STATIONS 440 TO 500.SDR AALA20120728003Vapor Barrier · crackedVAPOR BARRIER IS CRACKED ON THE LEFT SIDE AT BAY 6 LEFT. INSTALLED DOUBLERS IN VAPOR BARRIER BAY 7 LEFT PER SRMSUP 57-10-10-2R 2.
Back to N948AN