N903AN
Service difficulty reports · 281
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 = 'N903AN' 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 = 'N903AN' 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 AALA201902079016Shear Tie · corrodedAIRCRAFT WAS GROUNDED: CORROSION ON SHEAR TIE AT BS 907 BETWEEN S23L AND S24L. REPLACED SHEAR TIE PER EA 289535 AND SRM 51-40-02.SDR AALA201902079015Intercostal · corrodedAIRCRAFT WAS GROUNDED: CORROSION ON INTERCOSTAL BETWEEN BS 905 AND BS 927 AND BETWEEN S22L AND S23L. REPLACED INTERCOSTAL PER SRM 51-40-02.SDR AALA201901289035Skin · corrodedCORROSION FOUND ON FUSELAGE SKIN AT THE AFT LAV WASTE VENT. AIRCRAFT WAS GROUNDED. REPAIRED THE SKIN IAW SRM 53-70-01-2R-3SDR AALA2018052959017Girt Bar · detachedGIRT BAR CAME OUT OF THE SHROUD AT THE L4 DOOR. SECURED THE GIRT BAR IAW AMM 25-66-01. NO OTHER DEFECTS NOTED. AIRCRAFT OK FOR SERVICE.SDR AALA201801039016Spring · failedL1 DOOR HANDLE WAS FULLY EXTENDED AND ROTATED 90 DEGREES FROM LOCKED POSITION IN FLIGHT. REPLACED L1 DOOR HANDLE SPRING IAW AMM 52-11-00. OPERATIONS CHECK OK. THE ACFT WAS GROUNED.SDR AALA201712269054Sign · detachedEXIT SIGN NEAR BOTTOM LEFT OF FORWARD CATERING DOOR IS DETACHED. SECURED THE SIGN. OPS CHECKED OK.SDR AALA201712239002Sign · out of positionAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN OVERHEAD AT LEFT AFT GALLEY DAMAGED. REPOSITIONED EXIT SIGN TO PROPER PLACE.SDR AALA201706019019Lens · missingTHE AIRCRAFT WAS NOT GROUNDED. AFT RIGHT GALLEY EMERGENCY LIGHT LENS COVER REPORTED MISSING. REPLACED AFT RIGHT GALLEY EMERGENCY LIGHT COVER OK FOR SERVICE PER IAW AMM 33-20-00.SDR AALA201704259034Lens · detachedLENS COVER FOR EMERGENCY EXIT LIGHT AT THE R2 DOOR IS LOOSE AND CAME OFF. REPLACED EMERGENCY LIGHT ASSY IAW AMM 33-51-00. CHECKED OK.SDR AALA201703229035Lens · missingEMERGENCY EXIT LIGHT LENS COVER MISSING, 1R DOOR. EMERGENCY EXIT LIGHT LENS INSTALLED AS PER AMM 33-51-01. OK FOR SERVICE. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA20161202023Skin · wornAIRCRAFT WAS IN BASE MAINTENANCE. FORWARD CARGO DOOR OUTER SKIN IS WORN BEYOND LIMITS. REMOVED AND REPLACED SKIN IAW AARD 51-00-05-1, ESO 60654 REV 8 AND SRM 52-31-15.SDR AALA20160913001Battery · dischargedFOUND THE FLASHLIGHT OUT OF CRADLE AT AFT GALLEY LEFT FLIGHT ATTENDANT JUMPSEAT. REMOVED AND REPLACED FLASHLIGHT BATTERY AND SECURED AT CRADLE. OPERATIONS CHECKED NORMAL.SDR AALA20151020010Connector · damagedSEAT 17DEF AISLE LIGHTING CONNECTOR WIRE IS DAMAGED. REPAIRED 17DEF AISLE LIGHT CONNECTOR WIRE IAW SWPM 20-42-01. EMER POWER LIGHTING OPERATIONALLY CHECKED GOOD.SDR AALA20151019008Bulkhead Web · crackedLEFT & RIGHT MLG WW VERTICAL PRESS WEB CRACKS, BS 663.75. REPAIRED IAW EA 255444.SDR AALA20150618001Battery Pack · dischargedEMERGENCY LIGHT AT ROW 12DEF IS INOPERATIVE. R & R BATTERY PACK PAC5026 AT ROW 8 DEF. PERFORMED OPERATIONAL CHECK IAW AMM 33-51-06.SDR AALA20141028011Access Panel · corrodedCORROSION ON RT LE AT ACCESS PANEL 621CB BELOW SLAT TRACK. ACCOMPLISHED REPAIR IAW EA B737-57-037145.SDR AALA20141016008Splice · corrodedCORROSION FOUND AT STATION 888 BUTT SPLICE. REMOVED LIGHT CORROSION AT STATION 888 BUTT SPLICE IAW EA B737-53-036996.SDR AALA20141014010Support Angle · corrodedFORWARD CARGO FLOOR SUPPORT ANGLE AT BULKHEAD STATION 500 FROM LT TO RT RBL 24 CORRODED. INSTALLED NEW SUPPORT.SDR AALA20141014002Stringer · corrodedCORROSION ON STRINGER 22 RT FROM STATIONS 882 TO 894. SPLICED IN REPAIR IAW SRM 53-60-03-01, 53-70-52-1 & 53-00-03-2R.SDR AALA20141011002Floor Support · corrodedCARGO FLOORBOARD SUPPORT ANGLE CORROSION AT STATION 772 & RBL 13. REMOVED CORROSION ON UPPER SIDE OF FLOORBOARD SUPPORT ANGLE & INSTALLED SPLICE CHANNEL.SDR AALA20141007008Support · corrodedG4 GALLEY Z LEG SUPPORT CORRODED. R & R GALLEY SUPPORT.SDR AALA20141007007Support Angle · damagedGALLEY SUPPORT Z ANGLE HOLES ELONGATED. R & R GALLEY SUPPORT.SDR AALA20141006007Floorbeam · corrodedCORROSION ON FLOORBEAM AT STATION 986.5 AT FWD CLIP NUT HOLE RBL 43. R & R FLOORBEAM T CHORD REPAIR IAW SRM 53-70-51-2R-4.SDR AALA20141006005Channel · damagedFASTENERS PULLED THROUGH TRANSITIONAL CHANNELS FROM STATIONS 727 TO 847. R & R TRANSITIONAL CHANNELS.SDR AALA20141006004Intercostal · damagedINTERCOSTAL DAMAGED FROM STATIONS 827 TO 847. INSTALLED NEW INTERCOSTAL.SDR AALA20141006003Crease Beam · corrodedCORROSION AT STATION 986.5 FLOORBEAM. REPLACED CREASE IAW SRM 53-70-51-2R-4.SDR AALA20141006002Intercostal · crackedINTERCOSTAL CRACKED BETWEEN STATIONS 277 TO 328. REPLACED INTERCOSTAL.SDR AALA20141006006Floorbeam · crackedFLOORBOARD SUPPORT CRACKED AT STATION 537 & RBL 2 TO 24.75. R & R FLOORBOARD SUPPORT BRACE.SDR AALA20141003010Intercostal · crackedCRACKS IN INTERCOSTAL FLOORBOARD ATTACH HOLES FROM STATIONS 312 TO 328. INSTALLED SERVICEABLE INTERCOSTAL IAW AARD 51-10-0.SDR AALA20141017017Rivet · improper partTHREE BLIND FASTENERS INSTALLED AT STATION 926 FROM STRINGER 25 TO 27 RT. REMOVED & INSTALLED FASTENERS IAW EA B737-53-036996.SDR AALA20141002002Skin · bulgedBULGE IN UPPER SKIN OF OTBD AFT FLAP FROM PREVIOUSLY REPAIRED IMPACT DAMAGE. ACCOMPLISHED REPAIR IAW SRM 51-70-10-2R-4 FIGURE 202.SDR AALA20141001007Angle · corrodedRIGHT NR 1 DOOR HAS CORROSION ON CREASE ANGLE. R & R ANGLE IAW AARD 51-00-05-1.SDR AALA20140930010Angle · corrodedCORROSION ON LT CREASE ANGLE. REPLACED CREASE ANGLE IAW AARD 51-00-05-1.SDR AALA20140930006Door Frame · crackedRIGHT NR 1 DOOR FRAME CRACKED. REPAIRED STUB FRAME IAW SRM 51-70-11-2R.SDR AALA20140925009Shield · corrodedAFT CARGO TRANSITION SHIELD FROM RT STATIONS 767 TO 787 CORRODED. REPLACED TRANSITION SHIELD IAW 51-10-05.SDR AALA20141010010Fastener · pulledTHREE PULLED FASTENERS IN FRAMES ON RT TRANSITION Z CHANNEL FROM STATIONS 727 TO 767 RT. REPLACED IAW AARD 51-10-05-1.SDR AALA20141008002Transition Panel · corrodedFORWARD CARGO RT TRANSITION PANEL CORRODED FROM STATION 500 TO 500A. REPAIRED TRANSITION PANEL IAW AARD 51-00-05, DWG 143A0080 & EA B737-53-036846.SDR AALA20141007014Rail · corrodedCORROSION AROUND NUT PLATE FASTENERS. REMOVED CORROSION & PERFORMED SPLICE REPAIR IAW SRM 53-00-53-2R.SDR AALA20141007013Support · corrodedCORROSION AROUND NUT PLATE FASTENERS. REMOVED CORROSION & PERFORMED SPLICE REPAIR IAW SRM 53-00-53-2R.SDR AALA20140729017Web · damagedWEB ON HORIZONTAL BEAM GOUGED AT STATION 1125 AT LIGHTNING HOLE. REPAIR DOUBLER INSTALLED IAW EA B737-53-035936.SDR AALA20140725002Stiffener · corrodedVERTICAL STIFFENER AT RT STATION 1129 AFT INLET PLENUM & INLET ADAPTER ASSEMBLY CORRODED. REPLACED VERTICAL STIFFENER IAW AARD 51-10-05-1 & DWG 148A8650.SDR AALA20131010012Seat Track · crackedSEAT TRACK AT RBL 45.50 CRACKED AT FRAME STATIONS 727B, INBD & OTBD AFT HOLES CRACKED. ACCOMPLISHED REPAIR TO SEAT TRACK IAW EA B737-53-031995.SDR AALA20131010011Seat Track · crackedSEAT TRACK AT RBL 24.75 CRACKED AT FRAME STATION 727B, INBD & OTBD AFT HOLES. ACCOMPLISHED REPAIR TO SEAT TRACK IAW EA B737-53-031995.SDR AALA20131010010Seat Track · crackedSEAT TRACK AT LBL 45.50 HAS CRACKS AT FRAME STATION 727B, INBD & OTBD AFT HOLES. ACCOMPLISHED REPAIR IAW EA B737-53-031995.SDR AALA20131010009Seat Track · crackedSEAT TRACK AT LBL 24.75 CRACKED AT FRAME STATION 727B, INBD AFT HOLE. ACCOMPLISHED REPAIR TO SEAT TRACK IAW EA B737-53-031995.SDR AALA20121121009Spar · corrodedCORROSION ON RIGHT WING FOWARD SPAR AROUND BOOST PUMP BONDING STRAPS. REMOVED CORROSION AND REPAIRED PER EA B737-57-027149.SDR AALA20121124018Skin · corrodedCORROSION ON FUSELAGE SKIN FROM STATIONS 947 TO 987 BETWEEN STRINGERS 26 AND 27 RIGHT. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-027217.SDR AALA20121124017Skin · corrodedCORROSION ON FUSELAGE SKIN FROM STATIONS 927 TO 947 BETWEEN STRINGERS 26 AND 27 RIGHT. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-027217.SDR AALA20121124016Skin · corrodedCORROSION ON FUSELAGE SKIN FROM STATIONS 927 TO 947 BETWEEN STRINGERS 25 AND 26 RIGHT. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-027217.SDR AALA20121124015Skin · corrodedCORROSION ON FUSELAGE SKIN FROM STATIONS 947 TO 987 BETWEEN STRINGERS 25 AND 26 RIGHT. ACCOMPLISHED CORROSION REMOVAL PER EA B737-53-027217.
Back to N903AN